Tuesday, 12 January 2016

How to get the Top 10 Customers based up on Sales Volume


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