Refering Demension Value

[brijesh1991]

Hi,

In dimension of chart I have field: City

I have one excel which have CityExcel field:

In Chart:

I had dimension: City

Expression: Sum({$<CityExcel={'Delhi'}>}Amount) where Delhi comes from Dimension "City" field

I want to write a generalize expression, so that {'Take value from dimension'}

Please put ideas

[Gysbert_Wassenaar]

If your City field is independent of your CityExcel field and you select only one value in City then this expression should do what you want: Sum({$<CityExcel={'$(=only(City))'}>}Amount)