Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to refer to a calculated dimension in another calculated dimension in a pivot table ?
I created a dimension named Account. In another calculated dimension, I would like to have an expression using Account. Is it possible to refer to Account with its label ? It seems to me that it is not... Should I reproduce all the time the whole expression for the calculated dimension 'Account' ?
Thanks in advance
I do not think the Calculated Dimension expressions in a chart can be used or referred just like the Expression in a chart. Expressions in a chart can be reused just using the Label. If I find anything about it I'll inform you.
Using the label returns a integer value, whereas using the whole expression for the calculated dimension, this is working, but the performance is not satisfactory
Hi,
By using Column() in expression you can get dimension values, but for Calculated Dimension this won't works.
Regards,
Jagan.