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.
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)
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)
