HI Guys
i have time Dimemsion and hiriarchy as Year-month-week-day
i have a account Dimension
Actual as measure
i want to create a Calculated measure for Balance Account which is an member in account dimension
i want to create a calculated Cumulative measure for balance sheet account like the below
which should give me sum of cumulative of actual amounts for Required period
Time FY2010-Period1 FY2010-Period2 FY2010-Period3
Balance Sheet $2000 2100
4100
the above will calculate the Balance of previous month + current month so on
i hope i am making sense
Kind Regards
bhas
View Complete Post