EPM Formatting – Sub Total

[Former Member]

Hi

I have created Subtotal using ‘member sorting and grouping’ on EPM Member selector. I want to apply a different background colour for this Subtotal and lock them . Can anyone suggest on how to implement?

Thank you

Ram

[Former Member · Accepted solution]

Hi Raman,

please have a look at the following pictures. (don't be confused by some german words )

Member grouping are included as local member. (here named 'After')

You need to define a formatting for specific member / properties.

Regards

Steve

[Former Member · Accepted solution]

Thanks Steve

[Shrikant_Jadhav]

Hi Raman,

Use formatting sheet -> "Dimension Member /Property Formatting"

check local member default format -> format cell - > right click -> EPM -> Lock

Shrikant