Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. I've got pivot table with weeks placed horizontally and I'd like to hide columns in the first week, but leave the rest.
I want to hide selected columns, but leave the rest.
Is it possible to use some kind of IF at conditional value?
I tried if (FABRIC_CW = -1, FALSE(), TRUE()), but it's not working.
Create calculated dimension like
=If(FABRIC_CW <> -1,FABRIC_CW )
and check Suppress when value is Null
Try calculated dimension like:
If(FABRIC_CW <> -1, FABRIC_CW)
Then check 'supress when value is null' in the dmension tab itself.
Try with (editing the dimension)
if (FABRIC_KW = -1, Null(), FABRIC_KW)
and also check the box "Suppress Null Values"
Let me know
Yes, it works, but not the way I need it to work.
I need to have values from FABRIC_CW = -1, because I use them in further calculations, I'd like to only hide it, but without removing the whole CW.