Running Sum Filter issue

277 Views

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.