cancel
Showing results for 
Search instead for 
Did you mean: 

RowIndex()

Former Member
0 Kudos

I am trying to use RowIndex(). Beginner and struggling.

I have a table where i have ranked the stores by average order value. I have about 500+ stores. When I export to PDF, it is a long list. To avoid that, i need three blocks with 80 stores each and i am okay if it spills over one or two pages. Tried creating a variable as RowNum=RowIndex()+1 and stuck there. Any help is appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

are you getting some issues with filter? Create three blocks.Apply filter on first table with Rownum variable between 1 to 80.similar to oters.

Answers (2)

Answers (2)

Former Member
0 Kudos

No Amit. Doesn't work. I still face the same issue. Tried nofilter() in different ways.

Former Member
0 Kudos

Thanks for your quick response Amit. I tried this and I am able to get 80 rows. But the measures (Aov and the Rank) disappear. All those columns become blank. Tried readding the measures, adjusted formatting, doesn't help! I appreciate if you could help me.

amitrathi239
Active Contributor
0 Kudos

use nofilter() function in AoV and Rank variables and see.