Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My report lists top 100 products sold by the company.
Report layout as following :
===============================
top 1
..
top 10
Subtotal of top 1 to top 10
top 11
..
..
top 20
Subtotal of top 11 to top 20
Grand total of top 100
===============================
Did anyone experience with that kind of report?any solution on that . Thanks
Regards,
Kenny
Hi Kenny,
A Class of an Aggr in a pivot table should do the trick:
=Class(Aggr(Rank(Sum(Sales)), Product), 10)
Regards,
Stephen