12 month cumulative sum with variable interference

[reivax31]

Hi Qlikers,

I have a new challenge for you. I would like in a chart/table to perform a cumulative sum on 12month but depending on some variable value (v1, v2, etc...)  we peek either the "theoritical" value or the "real" value.

Attached you will find the expected results in an excel file to have a better look. I also made a test App.

Thanks for your help

[adrien_marchadi · Accepted solution]

Hey Reivax !

Find attached an app with some answer ...
I first calculated all rangesums (real, theorical and combined using variables), and then the rangesumdeviation

Note that I used this condition in the deviation :
if(rangesum real <> rangesum combined, rangesum combined / rangesum theorical -1)

Not really understand why you would want to do that, but that should do the trick !

[reivax31]

It worked perfectly ! thanks for your help on this one