Position Local member formula in Columns

[Former Member]

Hi All,

I hope everyone is doing great. I want to insert Total column in my report --- Report have multiple columns -- Col 1 , Col 2 and then Total ..

I don't want to create manually local member for all the Column.. There is a way that you create one local member and it get added to all the columns.

For instance prod 1, Prod 2, Total,   --- Same dimension prod 3, Prod 4 Total , I need to add total in all the columns--

Any ideas

Thank you

Neil

[former_member186338]

Hi Neil,

You have to explain what do you have in your row axis... If you have base members and you want to have sum of all base members then you create a local member after the row axis:

=SUM(EPMSELECTEDMEMBERS(DIMNAMEFORROWAXIS))

Vadim