Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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
Former Member
Not what you were looking for? View more on this topic or Ask a question