How to use Calculated Dimensions in set analysis

[vishus913]

Hi All,

Can we use calculated dimensions in  set analysis?

[sunny_talwar]

What exactly are you trying to do? Would you be able to elaborate with an example?

[kingsleyh]

Hi Vikas.

I think it depends on the Calc you are trying to do.

Something like the following will work:

SUM({<Year={$(=Max(Year)}>} Sales)

Many thanks

Kingsley

[vishus913]

I have Year as a dimension and a calculated dimension  which has 'cohort participant' and 'non cohort participant', and there is a single measure for them, now for each year i want to show two measures one for the 'cohort participant' and one for the 'non cohort participant' corresponding to each year.
but i can not apply conditions in set analysis on this calculated dimension. Is there a way i can do so

[kingsleyh]

Hi.

Please can you show me your calculation.

Sounds like you need AGGR()

[sunny_talwar]

From what you are saying, it should be possible, but I am not sure what you have to give you the exact syntax