sequence - to show all not only first 10? how to

Frequent Contributor

hi

 

I like to show the data in my pivot table as all not the first 10 as per the formula

 

=INDEX(FILTER('Input Data'!$G$6:$L$18,'Input Data'!$J$6:$J$18>$I$6),SEQUENCE(10),{1,2,4})

 

under sequence it show the first 10 only, how can I display al date , for row 1, 2, 4>

formula is right, just at it's showing first 10 items.  - 
Do I just removed the 10 in the ()?

 

do advise. thanks

 

Thank you

1 Reply

@bbsin 

Remove "SEQUENCE(10)".