Question on local member formula
I have a simple EPM report which shows accounts in rows and datasources and entities in columns. I have selected one datasource and several entities. The datasource is a fixed selected member, the entities are select as all base level elements of a node which have a specific property value.
I now need a total column in my report. When I let EPM do it I get a formula like:
Such a formula is not dynamic which means I need to update the local member every time I add a new entity.
I tried this:
But that only summed the final column, not all of them.
Can anyone help me on making this formula fully dynamic?
Vadim Kalinin replied
Still looks like that in all reports you have some fixed member in column axis and another is a list of members...
Anyway, magic formula for local member to sum from the first report column to the last report column:
P.S. Assuming that local member is in the next column after the last data column: "COLUMN()-1"!