cumulative data

[#1]

Hi,

If you make selection on any date , it should show cumulative sales from monthstart till the selected date.

How to implement in QV

[maxgro]

maybe with set analysis

sum({<Year={"$(=Max(Year)"},Date={">=$(=MonthStart(max(Date))) <=$(=max(Date))"}>}Sales )