Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've a problem which seems very simple :
I want to hide rows in a pivot table where expressions values are all equal to null()
BUT I want to keep lines where at least one expression value is equal to zéro.
Do you know how to do that ? (Or how to workaround it) ?
I've attached a quick sandbox example. As it may be more complex than it seems :), please try your solution
in this file before answering
Best regards
I used a calculated dimension:
=Aggr(If(not IsNull(Value), Code), Code)
With 'Suppress When Value Is Null' checked on the dimension tab
hi,
PFA
Is this?