Pivot Chart and Year To Date Dimension

[#1]

Hi I have a  pivot chart (attached).  Is there anyway to add an 'Year To Date' value at the end of the pivot row?? Ive attached an excel sample of what I need.

many thanks for any help!

Fiorano.

[Gysbert_Wassenaar · Accepted solution]

On the Presentation tab of the chart properties window select the Month dimension and check the option Show Partial Sums

[#3]

Many thanks!!!

Fiorano