How to not apply epmformatting sheet to a cell or row

[Former Member]

Hello, I have a report where I need to have one row(whihc is part of the report)where I need to disable epmformatting sheet. I dont want to create separate report for that. Is there a way to say "dont apply epm formatting sheet" to a specific row?

Thanks.    

[former_member186338 · Accepted solution]

The row has some row axis member(s). In the formatting sheet you have to define special format (like standard format) for this particular member.

Vadim

[former_member186338 · Accepted solution]

P.S. Look here:

Press the button to add specific row axis member and format this member...

[Former Member · Accepted solution]

yeah but that still applies, i need the epm sheet not to apply for a row as i want a dropdown.(data validation)

[Shrikant_Jadhav · Accepted solution]

Hi Manny,

As suggested by Vadim, you can select specific member to be formatted. Use data validation options from formatting sheet.  Please find attached.

Kindly provide some screenshot with example.

Shri

[former_member186338 · Accepted solution]

Yes, data validation can be applied using formatting sheet. In the data validation settings you can use fixed list or range with fixed address.

[Former Member · Accepted solution]

Hello Smith,

Enable 'Data Validation' in USE list,even if it is selected as 'ALL'

then follow process.

[Shrikant_Jadhav]

Hi Manny,

If you are use formatting sheet, it applies to full report (all rows and all columns ).

You can not exclude any row / column.

But explain what exactly do you mean by I need to disable epmformatting sheet ?

Do you want to different format for that row ?

Shri