Adding totals for a dimension on a pivot table

[kalpanaramjee]

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

[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.

[kalpanaramjee]

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.