Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Provide sample date please
i cannot share the data
You can obviously create dummy data.
I am afraid I cannot share a document from the Personal Edition. If you have any idea on a possible source of error in the syntax, please let me know.