Skip navigation
2015

Step1:

Create set [Top N]with customer name and select top [top N parameter]

Sales by sum               

[top N parameter]

 

[Top N] set

 

 

Step2:

Create [sub label] calc:

IF [Top N] THEN "Top " + str([Top N customers]) + " Customers" ELSE "Others" END

Step3:

Create expand and collapse parameter:

                        

Step4:

Create [Customer name] calc

IF [Expand or Collapse]="Collapse" THEN

    IF [Top N] THEN [Customer Name] ELSE "Others" END

ELSE     [Customer Name] END                                           

 

Step5:

Drag [sub label] and [customers name] into row and add sales into text and sort name by sales.