Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to have a text box or button where I could search on the following:
Sum( {<[Line of Business]={'Employee Benefits'}>} [Amount Revenue]) > 0
The user clicks on the button and the chart filters on customers that have a line of business of employee benefits with Revenue greater than 0
Any ideas on how to do this?
Zag
Try a Selection - Select in field button action with field
Customer
(or the field name for your customers) and search string
='=Sum( {<[Line of Business]={"Employee Benefits"}>} [Amount Revenue]) > 0'
Try a Selection - Select in field button action with field
Customer
(or the field name for your customers) and search string
='=Sum( {<[Line of Business]={"Employee Benefits"}>} [Amount Revenue]) > 0'
Hi, zagzebski.
See the example attached help.
I used a variable to receive the expression according to the click on the button. The table is filtered depending on action.
P.S.: if it works, adapt to their expression.
I hope this helps!
Thanks!
Thanks so much!