Ignore chart dimension in second expression

[#1]

Hi all,

as obect i need to ignore one dimension for the second expression of my stacked bar chart.

dimension:

time

cities

expressions:

count(people_city)

avg(people_all the cities) --> must ignore the cities dimension

Attached the chart structure without the second expression, i would like to represent the value of avg(people_all the cities) on top of every stacked bar.

How can i realize it?

Tx you!!!

[MK_QSL]

avg({<Cities = >}people_all the cities)

[tresesco]

May be like:

Avg( Total <CityDim> YourPeopleDim)

[#4]

refer to this case, I think it should be

Avg( Total <TimeDim> people_city)

[#5]

I tried both the ways,

but i lost dimension also for the first expression (attached the jpg)..

Where is my mistake?

[MK_QSL]

Can you upload your sample apps?

[#7]

It's a bit hard to extract the code.

The problem is that in the second expression i already have a set analysis with temporal filter, so now i should have

avg({<Cities = > * <temporal filter>}people_all the cities)

but in this way the city filter doesn't work and i continue to see all the city.