I have a pivot table with a calculated dimension which contains an aggr() on a complex field.
This field has an expression with form
$(=IF([Corporate Account]='OTHER',[Sales Account],pick(1+match('[Corporate Account]',...,...,...),...,...,...,...)))
The Calculated dimension is calculated... However, the condition IF([Corporate Account]='OTHER' is never met, although it should.
As a test, I created a dimension with
=IF([Corporate Account]='OTHER',[Sales Account],$(=pick(1+match('[Corporate Account]',...,...,...),...,...,...,...))
and the calculated result is correct....
Would you have an idea ?
Thanks in advance
