Skip to Content

EPM Formatting Sheet Priority Issue

Nov 03, 2016 at 08:14 PM


avatar image


Hello experts,

I have a priority issue between rows and colums while using EPM Formatting Sheet for changing their colours.

I gave priority to column formatting and defined a format for TIME and Parameter dimensions(both dimensions are in the column axis). Columns are greying out according to spesific Parameter members or TIME members. For example , if parameter P001 appears in the colums axis , formatting uses that selection. But if parameter P002 appears in the column axis , formatting uses TIME dimension's member to change column format.

My problem is , in addition to all these column members , row members will effect formatting also. But column formatting will remain the same without effecting one another's format.Only for spesific row members, row formatting will have the priority (not for all row members because of the effect of column formatting)(screenshot is attached to explain better what I am trying to attain)



picture.png (37.7 kB)
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Selin,

Can you share your formatting sheet?


* Please Login or Register to Answer, Follow or Comment.

0 Answers