topic Re: Pivot table subtotals in QlikView

Pivot table subtotals

Tue, 30 Sep 2014 12:42:11 GMT

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.

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

Re: Pivot table subtotals

giakoum — Tue, 30 Sep 2014 12:47:11 GMT

I would do it in the reload script by creating a new table as follows :

LinkTable:

GrouppedRegion, Region

Total, North

Total, South

North, North

South, South

and use GrouppedRegion as a dimension in the pivot table instead of Region

Re: Pivot table subtotals

Tue, 30 Sep 2014 12:55:47 GMT

Hi, thanks - this worked a treat and was so simple!!

I cant believe I didn't try that - amazing how sometimes you get so lost in a problem you cant see the simple solution in front of you!

Thanks again for the quick response.

Scott