I am new to IDT and have a basic question. I have created a calculated column in the data foundation layer using existing measures in the fact table. Can I use this newly created calculated column in the definition of another calculated column.
CC1 definition = Measure 1 - Measure 2 + Measure 3
CC2 definition = CC1 + Measure 4
I did not find a way to define CC2 without writing the whole formula for CC1 all over again (i.e. Measure 1 - Measure 2 + Measure 3 + Measure 4).
Any advice would be really helpful.