Getting cummulative measure value for given Month Year

system · August 19, 2009, 11:15am

Oracle DB
BOXI 3.1

Hi People,
I have a month Year column in DB as character (MMYYY) with measure Actual. I am showing values as:

MonthYear/Actual

Now I want to add a column which will bring in Cummulative value for that month for e.g. Jan->Jan, Feb-> Jan+Feb, Mar-> Jan+Feb+Mar.

Please guide in achieving this …

aneelf (BOB member since 2006-05-15)

system · August 19, 2009, 11:17am

Did you try using RunningSum() function?

Jansi (BOB member since 2008-05-12)

system · August 19, 2009, 11:23am

Superb!

How did I miss that. I was completely concentrating on achieving this through DB query.

Thanks Jansi

aneelf (BOB member since 2006-05-15)

system · August 19, 2009, 11:24am

Hi,

I guess Runningsum() function will be used.

Thanks & Regards,
Ramnaresh.P

ramnaresh (BOB member since 2009-03-18)

system · August 19, 2009, 11:30am

Thank you guys. Here is DB version to achieve the same (For Oracle).

Select Actual,MonthYear,MonhYearName,sum(Actual) Over (order by MonthYear) as Cummulative_Sum
from
[TableName]

I am still to check if it works best with designer/universe

Thanks again

aneelf (BOB member since 2006-05-15)