Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
So the value should not change based on selection in Manager field? May be this
=Sum({<City={'Pune','Mumbai','Delhi'}, Manager>}Population)
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.
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
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.
What are you trying to do?
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
No idea what you mean brother....
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)