I have a text object and List box and Bar chart.
Bar chart shows Expense by Location and List box has Locations listed.
I want the text object to show Expense only when a location is selected from List box or Bar chart ( when one of the bars is selected)
As of now Expense gets displayed only when Location is selected from List box and when I select one of the bars it doesnt show value..is this doable ?
Thank you.
Ex: Location is the dimension in Bar chart and the list box.
In text object I have the below expression:
if(GetFieldSelections([Location])>0,sum([Expense]))
I also tried
if(GetSelectedCount([Location])>0,sum([Expense]))
Thank you.
