Year to Date calculation based on Input Control

[former_member707123]

Hi,

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.

Period	Failures	Running Sum
2014.001	146	146
2014.002	180	326
2014.003	128	454
2014.004	236	690
2014.005	342	1,032

Please can someone help ?

Cheers,

posh

[former_member190694]

One of the option is to use the "between" condition for the input control by making the Period 1 always static. Another option is to create dynamic filter on Period which adds previous periods and use that variable for the input control.