Full Accumulation Division

marcel_olmo — Thu, 05 Dec 2013 15:58:58 GMT

Hi guys, I have a table which has current amount and last year amount. And I want the % of the difference in a cummulative format.

If I need to do this in a chart table, I can do it using :

Rangesum( sum([Current Amount]),above( [Current Amount Acc] )) where "[Current Amount Acc]" is the label of the column.

But what if I need the calculation of the % in one single column? I want to do a lines table.

Here's what I have with qlikview :

And this is what I'd like to have :

Any ideas? Regards, Marcel.

Here you have my qlikview document.

topic Full Accumulation Division in QlikView