Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Here's a screenshot of the table chart I'm currently working with:
So I'm trying to make a table that displays only the top 10 items where the quantity is the highest. At the moment, the table contains 134 items and these 134 items are displayed in the table chart.
Browsing this forum, I found a method using the "Limitation" functionality of a table chart. But, for some reason, the Limitation function is greyed out for me. Here's a screenshot:
So I'm wondering if there's a workaround to limit the number of items displayed using a function...I've been playing with the Rank() function with something like this...
If(Rank(Quantity) < 10, Item)
But I couldn't quite make it work as of now.
Any help would be greatly appreciated!
Thank you,
LesJean
Perhaps this?
If(Aggr(Rank(Quantity), Item) < 10, Item)
Perhaps this?
If(Aggr(Rank(Quantity), Item) < 10, Item)
This works! Thank you very much!