2 Replies Latest reply: Sep 30, 2014 8:55 AM by Scott Willis RSS

    Pivot table subtotals

      Hi, I have been using QV to develop reports and dashboards for a few months now and have always managed to find answers to any difficulties I have through existing discussion topics but this one has got the better of me so far!

       

      I have created a pivot table (screenshot below) which displays different product group sales by region depending on what is selected from the box on the left.

      pivot example.gif

      The challenge is that I need to show the totals for product group across both regions so I need another breakout underneath the South region showing Total that is split out by product group.

       

      Sounds simple but I cannot make it work - any suggestions / help on this would be very much appreciated.

       

      Thanks in advance,

       

      Scott