Basic question Give back the Top10 Customers:

Simple add a TopN filter to request:

Most manager won’t be satisfied with this report because there isn’t a time element present. Let’s add a year:

 

Okay what about the top10 for each year? Here is one solution:

First convert the filter to SQL:

Add a by to the TOPN Part:

TOPN("F1 Revenue"."1-01  Revenue  (Sum All)",10 by "D0 Time"."T05 Per Name Year" ) <= 10

What about showing the top 2 products for each top10 customer? I will discus that in part2.

Till Next Time