Hide Row when two values are 0

[#1]

Hi There,

I have a pivot chart that has about 12 calcuation fields on it.

I'd like to hide the rows if both of two caculations = 0 even if the other fields return values.

Can i do it without putting that test in each of the other 10 calcs?

Thanks

[Jason_Michaelides · Accepted solution]

You could try wrapping it in Aggr() and putting it in the dimension?  Or use Dimension Limits if you're on v11.

[#3]

Thanks that did work using Aggr().

[senpradip007]

You could use Dimension Limits if you're on v11.