9 Replies Latest reply: Jan 19, 2016 11:23 AM by James Summerson RSS

    Percentage of SubTotal

    Jim Morrison

      Hi Guys,

       

      I have recently been stumped trying to figure out how to create a % of a sub total.

       

      For example I have a pivot table showing something like this:

       

      County     City     Count of Sales

       

      UK           London          10

      UK           Liverpool        15

      UK           Manchester    75

       

      France     Paris              90

      France     Nice               10         

       

      So for the UK I would like to have another column saying 10% for London, 75% for Manchester etc.

       

      I have been trying to create this in Set Analysis using the Aggr function, however it always uses the total of the entire pivot table, not the sub totals!

       

      Any support would be massively appreciated!

       

      Regards