5 Replies Latest reply on Aug 30, 2016 4:26 AM by Shriram Saxena

    Dynamic Categorization of sales and finding number of customers

    Shaji Mathew

      Hi ,

      I have a case to categorize the total sales in 10 equal brackets (10 % of TOTAL sales) and identify the number of customers whose total sales falls under each category.

      For example, if total sales is 10000, and in the range of 5000-6000, there 56 customers whose individual total sales falls in this range and they constitute 16.16% of the total customers.

       

      I have attached the details in an excel.

       

       

      I do have some filters, the category and the result automatically readjust based on the filter selection.

      Can any one help.

      Thanks in advance..