Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kalpanaramjee
Contributor
Contributor

Adding totals for a dimension on a pivot table

Hi, I have created a pivot table with 2 dimensions, Province and month. Would like to create a total for the 3 months but it needs to show next to March. I have attached an example. Please assist. Thanks Kalpana

3 Replies
Gysbert_Wassenaar

Enable the Show Partial Sums option on the Presentation tab for the Province dimension. Use the Subtotals on Top or Subtotals at Bottom to show the totals where you want them.


talk is cheap, supply exceeds demand
kalpanaramjee
Contributor
Contributor
Author

Thanks but I need to see the total values for the months at the end. Jan + Feb + Mar = Total.

Gysbert_Wassenaar

Use the Subtotals on Top or Subtotals at Bottom to show the totals where you want them.


talk is cheap, supply exceeds demand