Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning!
I have a straight table with about 400 rows, and I would like to display only the top 20 so employees can focus on those. Looks something like this (except several more columns):
Client | Name | Revenue |
10089 | Bob's Business | 80000 |
10087 | Pizza Shack | 60000 |
10074 | Car Parts Etc | 40000 |
I have it sorted by revenue, as we need to focus on higher revenue clients. What is the best way to do this? What expression would limit the rows. I have read through some options with firstsortedvalue, and something similar to this: if(rowno(total)<=20,Expression), but I can't get anything to work out.
Under the straight table options:
Please help me stop the madness-I've been staring at this and researching for far too long.
Thanks!
Jenny
Limiting the number of rows is generally done in Data Tab with 'Limitation' option but as you mentioned this is greyed out for you, maybe you can share the file.
hi
assuming Client and Client Name are dimensions and Revenue is a measure
go to Client , under the field properties you'll find the limitation dropbox select fixed and set the number to 20
Just figured this out myself:
Column1 = dimension that you want to reduce
Column2 = measure: only(column 1 dimension).
Limit column 1 to top or bottom 10, it'll calculate on Column2
hide Column2