Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)