Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
Highlighted
kalpanaramjee
New 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
MVP & Luminary
MVP & Luminary

Re: Adding totals for a dimension on a pivot table

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
New Contributor

Re: Adding totals for a dimension on a pivot table

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

MVP & Luminary
MVP & Luminary

Re: Adding totals for a dimension on a pivot table

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


talk is cheap, supply exceeds demand