EPM Conditional formatting

[Former Member]

Hi,

I Want to do the formatting liks this, is it possible..

please suggest

Regards.

Surya

[rishi4892 · Accepted solution]

Hi Surya,

You can achieve those formatting, see below steps to do that.

Thanks,

Rishi

Steps :

1. Write 0 and 1 on top row based on conditions see screenshot below.

2. Go to EPMFormatting sheet -> Dimension Member/Property formatting,  select priority to row format

and check check options calculated and inputtable, now select data cells of both and write conditional formatting. see below screenshots

Here in formula "F" refers to your first column of Report.

3. Now go to your sheet and Refresh. Your sheet will look like

4. Now go to Formatting sheet , and add member for which you want complete formatting on that row

5. Go to your sheet and Refresh.

Hope This will be helpful.

Thanks,

Rishi