Adding summary columns in pivot table

[smith180579]

Hi all.

I have an issue I do not know how to solve.

The pivot table that reflects the monthly sales for the current and previous year in the attachment .

Last two columns should be summary.

First summary column should reflect sales amount starting from the beginning of the current year till selected month of current year (e.g. jan,20-apr,20).
Second summary column should reflect sales amount starting from the beginning of the previous year till selected month of previous year(e.g. jan,19-apr,19).

Thanks in advance!

[rubenmarin · Accepted solution]

Hi, in presentation tab you can check the option to show partial sums on 'MY' dimension:

[smith180579]

Thank you very much!