Calculation of Column Data

[Former Member]

Hello Experts,

Following is the sample report that I have created.

Here the Column Headers(Cells boxed in BLUE) reference the cells that are boxed in RED; So here the columns change dynamically based on Context Member selection of Time Dimension.

What I want to do is to calculate the Quarter as sum of the First Quarter ( 01;02;03), likewise for Second Quarter, Third Quarter and Fourth Quarter and this calculation must be dynamic.

I was suggested to use the Custom measures but I would like to know if that is feasible for my current requirement.

In addition, please find the measure formula that was taken from SE38 TCode

'IIF([%COST_CENTER%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM(PERIODSTODATE([%TIME%].[%TIMEQUARTERLEVEL%], [%TIME%].CURRENTMEMBER),[MEASURES].[/CPMB/SDATA]),IIF([%COST_CENTER%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM(PERIODSTODATE([%TIME%].[%TIMEQUARTERLEVEL%], [%TIME%].CURRENTMEMBER),[MEASURES].[/CPMB/SDATA]),IIF([%COST_CENTER%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),IIF([%COST_CENTER%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3

Kindly advise on the above requirement.

Regards,

Sachin

[former_member186338 · Accepted solution]

Sorry, but not clear!

Looks like you didn't understand everything I have already posted in reply to your questions!

Don't combine actual and forecast in the same report!

Use only Forecast! Copy Actual to forecast...