on 07-18-2018 7:58 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No Amit. Doesn't work. I still face the same issue. Tried nofilter() in different ways.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.