Textbox excluding values

[#1]

hi,

I have textbox which needs to calculate on the basis on Month filter only. It can be done but point is that I have used following formula.

=Sum({<City={'Pune','Mumbai','Delhi'>}Population)

same formula I have used in particular chart expression ( dimension - Manager).

I want it should calculate the number in text box with same formula BUT SHOULD NOT CHANGE ONCE I CLICK ON DIMENSION IN CHART.

Thanks,

Narendra

[sunny_talwar]

So the value should not change based on selection in Manager field? May be this

=Sum({<City={'Pune','Mumbai','Delhi'}, Manager>}Population)

[#3]

Thanks,

If I take dimension as a CITY and following formula for textbox

=Sum({<City={'Pune','Mumbai','Delhi'>}Population)

Then? what should we do ?

Thanks again.

[sunny_talwar]

Is the field name City or CITY? Make sure you are consistent and use the correct casing.... Also, you are missing a closing curly parenthesis.

=Sum({<City={'Pune','Mumbai','Delhi'}>}Population)

The above expression should not change when you make selection in City field

[#5]

Sorry was typing mistake.

Thanks,

If I take dimension as a CITY and following formula for textbox

=Sum({<City={'Pune','Mumbai','Delhi'}>}Population)

Then? what should we do ?

Thanks again.

[sunny_talwar]

What are you trying to do?

[#7]

Textbox should Sum of populations for 'Pune','Mumbai','Delhi' only which could not change if I click on charts dimension.

but dimension should show all the data of CITY

[sunny_talwar]

No idea what you mean brother....

[neelamsaroha157]

For Text box use expression as suggested by stalwar1‌

=Sum({<City={'Pune','Mumbai','Delhi'}, Manager>}Population)

and for your chart keep your expression simply as

=Sum(Population)