Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could try wrapping it in Aggr() and putting it in the dimension? Or use Dimension Limits if you're on v11.
You could try wrapping it in Aggr() and putting it in the dimension? Or use Dimension Limits if you're on v11.
Thanks that did work using Aggr().
You could use Dimension Limits if you're on v11.