Set Analysis Help

[arusanah]

HI Friends ,

I am writing a calculated dimension

=only({<[%KPI_KEY]={'ARIEL'},Metric=}>}if((DATE <= END_DT and DATE >= EndMonth13 ),MonthYear))

it doesn't throw error instead says invalid dimension.  Can anyone help ?

[vunguyenq89]

Make sure all fields being used in the expression do exist in the data model.

Can you provide a sample app?

[Quy_Nguyen]

Try this:

Aggr(only({<[%KPI_KEY]={'ARIEL'},Metric=>}if((DATE <= END_DT and DATE >= EndMonth13 ),MonthYear)),MonthYear)