In a pivot table, I have one calculated dimension with complex expression:
pick(1+match(IF([Corporate Account]='OTHER','[Sales Account]', '[Corporate Account]'),...,...,...),...,...,...,...)
In another dimension, I want to sum revenu with respect to this first dimension. More precisely, I want to have value for this new calculated dimension be 'A' or 'B' depending on the total revenue with respect to the first field.
So far, I came up with
=AGGR( IF(Sum(Revenue)>10,'A','B'),
$(=pick(1+match(IF([Corporate Account]='OTHER','[Sales Account]', '[Corporate Account]'),...,...,...),...,...,...,...)))
and this is not correct (for all rows, output is Null()).
Would you have an idea of what is the right syntax ?
Many thanks in advance
