Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Refer to a calculated dimension in another calculated dimension

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

3 Replies
sudeepkm
Specialist III
Specialist III

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.

Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

By using Column() in expression you can get dimension values, but for Calculated Dimension this won't works.

Regards,

Jagan.