Is it possible to refer to a Calculated Dimension in another Calculated Dimension in a Pivot Table ? Can ValueList() be used for this usage, and what would be the appropriate syntax for it ?
I cannot use the script for this, and I cannot create a new variable either.
I cannot copy the whole expression for the first calculated dimension in the expression for the second calculated dimension as both expression are very expensive (pick(match(...)).
Thanks