Skip to Content
avatar image
Former Member

Year to Date calculation based on Input Control

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 18, 2015 at 03:14 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded