topic Cumulative sum In Pivot Table in QlikView

Cumulative sum In Pivot Table

Wed, 25 Nov 2020 16:16:04 GMT

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

The sum total for selected month
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.

Re: Cumulative sum In Pivot Table

el_aprendiz111 — Wed, 23 Aug 2017 15:53:45 GMT

Hi,

You can share qvw

Re: Cumulative sum In Pivot Table

devarasu07 — Wed, 23 Aug 2017 16:04:03 GMT

Can you share mock data, try like below

Expression as YTD Cumulative:

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

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

also check this,

Accumulative Sums

Thanks,Deva

Re: Cumulative sum In Pivot Table

Thu, 24 Aug 2017 08:20:08 GMT

Hi,

Please find attached the dummy data.

Re: Cumulative sum In Pivot Table

Thu, 24 Aug 2017 08:21:20 GMT

Thank you Devarasu. Attached is the file.

Re: Cumulative sum In Pivot Table

devarasu07 — Thu, 24 Aug 2017 16:04:20 GMT

Hi,

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

Re: Cumulative sum In Pivot Table

sunny_talwar — Thu, 24 Aug 2017 16:12:26 GMT

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

Re: Cumulative sum In Pivot Table

sunny_talwar — Thu, 24 Aug 2017 16:18:21 GMT

Check the attached

Re: Cumulative sum In Pivot Table

its_anandrjs — Thu, 24 Aug 2017 16:19:03 GMT

Try with combination of the RangeSum on pivot table.