Duplicate Running Total Grand Total In Pivot Table
 

Good Morning All, XL2007
I have a basic PT summing values across a row of months

A B C D
Overheads 10 10 10
Expenses 20 20 20
Grand Total 30 30 30

Now I wish to insert another Grand Total Row which will show
the Running Balance ie

A B C D
Overheads 10 10 10
Expenses 20 20 20
Grand Total 30 30 30
Grand Total(2) 30 60 90

I know I could add a seperate row outside the PT to reflect the
Running Total, but would rather keep it included, via a
Calculated Field or such like.
I have managed to contrive a Calculated field, but this returns Subtotal
rows
for the Running Balance for all my Subdivisions, eg Overheads, Expenses etc.
I wish just the Grand Total(2) to show the Running Balance.

Is there a way?

As usual thank you for any input.
Cheers
Mathew

Duplicate Running Total Grand Total In Pivot Table
 

Use sumproduct. Put this formula in column B the copy across all your columns

=sumproduct(--($A1:$A1000="Grand Total"),B1:B1000)

Row 1000 is the row before the final grand Total. Therefore this formula
will go in the next row B1001.

"Mathew P Bennett" wrote:

Good Morning All, XL2007
I have a basic PT summing values across a row of months

A B C D
Overheads 10 10 10
Expenses 20 20 20
Grand Total 30 30 30

Now I wish to insert another Grand Total Row which will show
the Running Balance ie

A B C D
Overheads 10 10 10
Expenses 20 20 20
Grand Total 30 30 30
Grand Total(2) 30 60 90

I know I could add a seperate row outside the PT to reflect the
Running Total, but would rather keep it included, via a
Calculated Field or such like.
I have managed to contrive a Calculated field, but this returns Subtotal
rows
for the Running Balance for all my Subdivisions, eg Overheads, Expenses etc.
I wish just the Grand Total(2) to show the Running Balance.

Is there a way?

As usual thank you for any input.
Cheers
Mathew