cumulative

[MauriceLudo]

Hello,

I need your help please, I want to calculate the cumulative amount

For example if I select filters in April of the year selected (or selected years), the amount displayed must be the sum of (January + February + March + April) for the year or the selected years .

I tested

= Rangesum (Above (Sum (Sales), 0, [number months])) unsuccessfully

With either set analysis

sum ({<= Years, Months =, DateNum = { "$ (= '> =' & vMinDateCalSMART & '<=' & vMaxDateCalSMART)"}>} ACTUALERP_S) / Weight

Thanks for your help

[Gysbert_Wassenaar]

We can play a guessing game and blindly make guesses until somebody guesses correctly. But this can be resolved a lot faster if you can post a small qlikview document that contains some relevant data. That way we can see what values your fields contain and what your variables contain.