Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have three dimensions, group, GL codes and Center, where Center is in the Horizontal axis and other two are vertical, with one expression, now if i tried to add an expression it creates another column whereas I need it to be in the dimension,
say if I need to add and expression gross contribution, I need to to be just below the Direct Variable cost as in the screen shot attached
Please help
regards
Arjun
I think it's not possible
Its not possible to just add it as a new row, but you can create a custom field in the data model that maps in a new dimensional value (gross contribution) and associate it through a table join to the required values.
In its simplest form , you would then add 'if () ' formulas to each expression to calculate differently depedning if its gross contribution or not.