In my case, i have measure: Income
in Dimensions i have Year and Income Type
I must split Income in 3 Types which i have in Measure IncomeType.
Solutions like
IF Type='P' then Income END
or
Case IncomeType
WHEN Type='P' Then Income1=Income
....
Any idea how to solve that?
2 answers
The first thing I would do is convert the IncomeType filed to a Dimension. Next write a calculated field with a case statement that starts Case IncomeType....
