Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Would you be able to share a sample to show the issue?
Please upload a sample
May be it is easier to help if you could share the sample!