Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to display the top 20 rows split into two straight tables. My table has only one dimension column. The rest are all measure columns. The Top N is calculated on the first measure column.
The first table should show the Top 10 rows. I've achieved this by setting the limitation to a fixed number and entering a value of 10. I want the second table to show the subsequent 10 rows, i.e. 11 to 20. I tried implementing this with the following formula :
If(Match(RowNo(), 11,12,13,14,15,16,17,18,19,20), DimensionField)
It doesn't work for this table. But this worked formula worked for me when I used it on a table with dimensions only.
I would appreciate any help in solving this issue.
Perhaps something like this while suppressing null
=If(
Aggr(Rank(Measure), Dimension) > 10
and Aggr(Rank(Measure), Dimension) <= 20,
Dimension
)
Perhaps something like this while suppressing null
=If(
Aggr(Rank(Measure), Dimension) > 10
and Aggr(Rank(Measure), Dimension) <= 20,
Dimension
)
Thank you for the solution! This worked exactly as per my requirement.