3 Replies Latest reply on Sep 27, 2016 9:19 AM by Matt Hong

    Display subtotals for category based on percent of total sales

    Nichole Collier

      I'm trying to include subtotals for categories based on percent of sales..

      I've set up an example using Superstore (attached below).

       

      I would like to include the Top 5 products by region (based on sum of sales), the percent of sales for each product in that region AND the subtotal for that region. This way I can see how much the sales of these top 5 products contribute to that region.

      To find the Top 5 products, I created an Index() field called Rank, sorted by sum of sales and then filtered the Rank field for top 5.

       

      When I select Analysis--Add all Subtotals, it only will display 100%.  Any help would be appreciated.

       

      Thanks!

      Top 5 products by region total.JPG