a Ranking Sub total

[#1]

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

[stephencredmond]

Hi Kenny,

A Class of an Aggr in a pivot table should do the trick:

=Class(Aggr(Rank(Sum(Sales)), Product), 10)

Regards,

Stephen