Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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