OBIEE running sum Using Dashboard Prompt

3152543

Hi guys,

I have a specific requirement which I'm not able to create using Dashboard prompts and column formula rsum() in criteria(not in pivot table) .

For example,

MONTH NO.               ITEM SOLD          rsum(items SOLD)

     1                                   5                         5

     2                                   3                         8

     3                                   5                        13

     4                                   8                        21

     5                                   4                        25

     6                                   6                        31

I've created the above columns in the criteria.

And i have a Dashboard Prompt to get the range of month no.(Using the 'in between' filter).

If i select month 3 to 5

Desired RESULTS:

MONTH NO.

ITEM SOLD

rsum(items SOLD)

3	5	13
4	8	21
5	4	25

But these are the results I get:

MONTH NO.                         ITEM SOLD               rsum(items SOLD)

3	5	5
4	8	13
5	4	17

Is there any way to get the desired results. Thank you in advance.