Sum of Rows in pivot table

[Anonymous]

Hi, I have a pivot table like this:

                  DIM3                    A                    B            

DIM1          DIM2

A                Jan 2015               10                   20            

B                Feb 2015               20                   30

I want to count row A so the total will be 10 +20 = 30 and also Row B so the total will be 20+30 = 50.

The result i expect is like this

                  DIM3                    A                    B               TOTAL  

DIM1          DIM2

A                Jan 2015               10                   20              30

B                Feb 2015               20                   30              50

Is it possible to make it ? I also have an expression =sum(quantity)

Really appreciate your help .Thanks

[MK_QSL · Accepted solution]

Go to Presentation Tab

Select DIM3 and tick Show Partial Sum

Subtotals

Subtotals at Bottom

[Anonymous]

like this?

[Anonymous]

Hi,

You both are great problem solvers. It solves my problem perfectly.

Thank you very much.