total at the far right in pivot table

[alexpanjhc]

Hi

I have a pivot table that is working. Now I wanted to add a total for the row at the far right and I also need to have a grand total for this total.

How do I achive this?

example below, i want to have the total column in my pivot table which is not now.

Product   Jan    Feb  March   total

A               10     20     30          60

B               1       2       3            6

total           11     22     33          66

[alexpanjhc · Accepted solution]

never mind   i asked a stupid question lol.

i just need to check the partial total and it will show.