There are several ways to get the Top 10 Customers based upon Sales Volume, Sets concept is used to illustrate here.
1) Right click on [Customer Name], click on "Create" then click on "Set".
2) Define the set Name, and select the field name [Sales] , and few more are as below image
TOP, SUM, 10.
3) Drag the [Customer Name] on to Rows shelf, drag the Set onto Filters shelf.
4) Now view shows our desired result "Top 10 Customers based up on Sales Volume".
No comments :
Post a Comment