Showing results for 
Search instead for 
Did you mean: 

Running Sum Filter issue

Former Member
0 Kudos

Hi Everyone,

I am trying to create a RunningSum for the [Number of Users] in particular table. XIR3, Webi, SQL Server DB As an example, lets say the report w/o filters would look something like this:

Month Jan-09 Feb-09 Mar-09 Apr-09 May-09
# Users 2 1 2 4 1
RunningSum 2 3 5 9 10

The catch is I need to show the overall running sum but allow users to prompt for a Date Range (say [Date] between 3/1/09 and 5/31/09). The report should display:

Month Mar-09 Apr-09 May-09

# Users 2 4 1

RunningSum 5 9 10

AND NOT!! (look at difference in the running sums):

Month Mar-09 Apr-09 May-09
# Users 2 4 1
RunningSum 2 6 7

Make sense? I've tried all sorts of multiple queries, sub queries, block filters, variables, NoFilter() etc just cannot find the right combination. Please let me know how I can clarify.

Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos


if it is prompted, you dataset will be overall filtered,

if you use input controls upon the dataset, the no filter will work, because all the dataset is uploaded first.

if you really want a prompt, you should calculate it on universe level



Former Member
0 Kudos

No one on this ???

Thought this issue should be a common one. How do people calculate inventory or working capital via Cumulative KeyFigures in BW but use them in BO WEBI reports.

If anyone has faced this kind of issues before, kindly reply here.

Rgds, Sree