Year to Date calculation based on Input Control
My requirement is to calculate Year-to-date values based on the period values selected by users via input controls.For example if period 004 is selected, then the Year-to-date measure on the graph must display the total value of the first 004 months .
The data is based on a Bex query using BICS.
I got the running sum working....but the moment I select say Period 4 then the value should show me 690 and not 236.
I cannot use Nofilter() as users wants to drill on other dimensions.