horizontal cumulation in pivot table

[#1]

Hey Guys

I would like to add a column to my pivot table which cumulates the values up to the current month. At this point the table looks like this:

In other words, there should be a Column each time after "IST" that cumulates the "IST" values. Referring to this example it should look like this:

Unfortunately the function Cumulate as well as my set analysis formula isn't working. Could someone please help me with this problem?

regards

Sebastian

[tresesco · Accepted solution]

Try like:

Cum IST: =RangeSum(IST, before(Cum IST))

[#3]

Hi Tresesco - that worked like a charm, thank you very much!

[#4]

Hi Tedesco,

Unfortunately i found some errors in the calculation:

If you look at the graphik above, all marked rows are being calculated wrong. The second last column (IST kum.) is the calculated cumulative sum (i exported the numbers to excel in order to make it more clear, in the actual report all the cumulative sums are available). The last column is the correct sum calculated in excel.

Has anyone an idea why this formula sometimes works and sometimes not? I couldn't find any patterns...

Thanks,

Sebastian

[tresesco]

Try to share your sample qvw that demonstrates the issue. See: Preparing examples for Upload - Reduction and D... | Qlik Community