Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody
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,
Sum(Aggr( .....
If(Dimensionality() = 1,
Sum(Aggr(....,
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( ...
Regards
Philippe
>>Is there a syntax that alows me to write only one time the expression (as the fonction "OR" in excel) ?
If(Dimensionality() = 0 Or Dimensionality() = 1, .....)
If the aggr() includes all the chart dimensions, then you would not need a separate logic for the subtotals and totals, so you would not need the Dimensionality() split. Unless, of course, you need different logic, like and Average at the totalling levels and a sum at the detail levels,
>>Is there a syntax that alows me to write only one time the expression (as the fonction "OR" in excel) ?
If(Dimensionality() = 0 Or Dimensionality() = 1, .....)
Hi Jonathan
thank you for your explanations
in my case
If(Dimensionality() = 0 Or Dimensionality() = 1
is all right !
regards
Philippe