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]

Hi Neil,

As per my understanding you can check "Active Local Member Recognition" in the report Options tab & then you can insert the formula in one cell of the column then it will create for the rest of them.....

I hope this will help you but if you had any further quries kindly show your requirment clearly in a Excel sheet so that we can understand & We can make a try to give you correct solution....

Aravind

[Former Member]

Hi Karsten,

Thanks for your very detail explanation issue is resolved.

Neil