Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a pivot table with more than 20,000 row items. Is it possible to have some functions like showing
1. First 5000 entries, then,
2. From 5000 to 10000 entries
3. From 10000 to 15000 etc...............till 20000
Any ideas?
Renjith
thanks for the response!! this will give you a rank, i want data "between" not from top. . Thanks...
Hi,
Try this
sum({$<Product = {"=rank(aggr(sum(Sell),Month))>= 2 AND rank(aggr(sum(Sell),Month))<= 10"}>} Sell)
2 and 10 are start and end values to be displayed.
Regards,
Jagan.