Searching with Set Analysis

[zagzebski]

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

[swuehl · Accepted solution]

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'

[jonas_rezende]

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!

[zagzebski]

Thanks!

[zagzebski]

Thanks so much!