How to Select an Offset?

[Trever]

I've got a table with several dozen associate names and performance numbers. The entire list isn't visible at once, so I'd like to create three side-by-side tables. Table 1 would show associates 1-10, Table 2 would show 11-20, and Table 3 showing the remainder.

I've tried to use the TOP() function in Limitation, but that doesn't seem to work.  

This isn't a static list, so I can't specify A-F, or by employee id, etc. Need to do something similar to the SQL LIMIT and OFFSET functionality.

Creative ideas on how to accomplish this?

[stevejoyce · Accepted solution]

I would use rank().  

if you don't need totals for all associates (if that's what your splitting by), you can do a calculated dimension.  otherwise use it in your table's expressions.

sum({< field = {"=rank(rank(field)) <=10"} >}  measure)

sum({< field = {"=rank(rank(field)) <=20 and rank(rank(field)) > 10"} >}  measure)

[Trever]

Thanks - I learned something new!