This content has been marked as final. Show 3 replies
i have a PIVOT TAB like this
I created Aggr expressions with ratios and i use IF( dimensionality () for TOTAL and SUBTOTAL calculations like this
If(Dimensionality() = 0,
If(Dimensionality() = 1,
it's working perfectly, but i think it's a too complicated syntax
Is there a syntax that alows me to write only one time the expression (as the fonction "OR" in excel) ?
like this :
If(Dimensionality() = 0, OR 1,
Sum ( Aggr( ...