Cumulative Values in a pivot table

[#1]

I have a simple pivot table and I want it to show all cumulative values for each year.

See attached example.

Would appreciate some help.

Thanks

[#2]

I think you are getting total by year, Not sure what you are looking for.

Please see attached.

[#3]

What I want to see is the value in the months to accumulate down each column in the table so that the *** value for dec in each year is the same as all the months in the year added together.

[brenner_martina]

Hi,

The answer is:

=

sum(Value)+

If(Not IsNull(Above(sum(Value))),Above(sum(Value)),0)