4 Replies Latest reply on Feb 15, 2016 5:31 PM by savinay sehgal

    Calculate sales For Top 10 Customers and then Compare that with Total Sales

    savinay sehgal

      Hello,

       

      I am trying to compare the Sales of top 10 customers in every product sub category to the total sales in that sub  product category. I have calculated Ranks and I am able to find out top 10 customers in every product sub  category but I am not able to compare the Sales of these customers with Total Sales in that sub category.

       

      Could you please help me in this. Attaching the workbook here.

       

      Thanks,

      SS