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 Member · Accepted solution]

Hi Neil,

there is a simple and standard way for achieving your requirements. BPC itself provides the solution for you.The number of columns doesn't matter at all. It will show the sum for all your columns. As confirmation please see the screen below to make sure I met your requirements:

Report:

The report above shows the desired result without any manual entered local member. For achieving this simply create a report with a dimension in rows (here entity) and your dimension PRODUCT in columns. Select in your REPORT member selection the desired products to be summed up - here I took ProductA and ProductB. Now go to the sorting properties for the product dimension in EPM Editor and make the settings as follows:

1. Enable Member Sorting

2. Group by Property HLEVEL

3. Select AFTER tab

4. Set flag Create Local Member Named - After (once you set the flag the local member formula will automatically filled by system)

5. Press OK

Now you got a report with ProductA and ProductB in columns plus a TOTAL column. After these steps create a new report with sharing row axis. Select the new products - I took ProductA and ProductC. Repeat the sorting settings described above and you will get the report shown in screen.

There are several ways to achieve your calculation elements. One thing is to create a property in product dimension wich identifies the calculation elements. Referring in sorting properties to that property (instead of HLEVEL) will enable you to have just one report instead of two or more with the same result as shown above.

Hope this will help you,

Karsten