pivot table - overall acomulative sum

[smig]

is it possible to have an overall acomulative sum in a pivot table ?
I know I can have it over the row or column.

attached an example of what I want

thanks,
Tal

 

[noboffinme]

Hi smig

I'm not sure what you mean & the snapshot isn't helping me much.

You probably know that you can have (or not have) Sub Totals for each value in the 'Row' area & you will get an overall 'Grand Total' at the bottom of the pivot.

Is it the Sub Total you're talking about when you say 'overall acomulative sum'?

 

[smig]

no. it's not the sub totals that I'm looking for
What I want is every cell (in the second table) to be the sum of all the top-left cells (of the first table)

 

[NBVC]

Have you tried quering "Running Totals Pivot Tables" in Google? You may find some ideas. Here is one place: http://www.contextures.com/xlPivot14.html

Without seeing some actual data (the data can be made up) and the pivot table you get and want, it is not easy to help you.

 

[smig]

Thanks, but these are the totals for rows or columns, not both as I wanted.
The picture I attached show how I want it to look like