TM1 Forum

Hi all,

I'm stucking with issue as the image below.
Is there anyway to keep that format ?

Thanks all,
Tin Pham

Is this a slice or an active form? A slice will usually automatically do this for you. And with an active form you can control the formatting using the hidden rows at the top of the sheet.

Alternatively you could put an ellev in a hidden column to determine whether the element is consolidated or not, and then apply conditional formatting based on that ellev result.

Martin

Martin Ryan wrote:Is this a slice or an active form? A slice will usually automatically do this for you. And with an active form you can control the formatting using the hidden rows at the top of the sheet.

Alternatively you could put an ellev in a hidden column to determine whether the element is consolidated or not, and then apply conditional formatting based on that ellev result.

Martin

Thanks Ryan, i did it as you said !

phamtinkt88 wrote:

Martin Ryan wrote:Is this a slice or an active form? ....
Martin

Thanks Ryan, i did it as you said !

Tin, he is too polite to say so but his first name is Martin!