Cumulative sum In Pivot Table

[#1]

Hi,

May I ask for help to show the cumulative sum in a pivot table. I tried the related threads but could not get any answer, so posting a new one.

Problem

I have a table which shows value for some items across the year.

I need to create a pivot table where I need to show 2 columns only

1. The sum total for selected month
2. The YTD figure till the selected month. (if Jun is selected then sum of JAN+FEB+MAR+.......+JUN) Need HELP HERE

I tried using SumRange for the YTD, but could not crack it. I don't want to show the full table, but to do the calculation in the formula and show the final YTD value.

Like this

Please help.

[el_aprendiz111]

Hi,

You can share  qvw

[devarasu07]

Hi

Can you share mock data, try like below

Expression as YTD Cumulative:

rangesum(above(column(1)),sum(Sales))

or

RangeSum(Above(total sum(Sales), 0, RowNo(TOTAL)))

also check this,

Accumulative Sums

Thanks,Deva

[#4]

Hi,

Please find attached the dummy data.

[#5]

Thank you Devarasu. Attached is the file.

[devarasu07]

Hi,

if it's working fine. can you close this thread by marking correct or helpful. tks

[sunny_talwar]

I suggest using The Crosstable Load to transform your data and then use set analysis here...

[sunny_talwar]

Check the attached

[its_anandrjs]

Try with combination of the RangeSum on pivot table.