Using expression in trigger (Select in field)

[aisolomatin]

Hello,

I need help with the expression for trigger.

I would like to make Text object with trigger for filtering values.

I got a simple load script:

Load * Inline [

product,amount,quontity

product1,100,10

product2,80,4

product3,120,5

];

I've made pivot table with expression"Price"=sum(amount)/sum(quontity).

I need to filter values with Price>15 by clicking on Text Object.

[sunny_talwar · Accepted solution]

May be using this as the search string:

='=Sum(amount)/sum(quontity)>15'

[aisolomatin]

Thank you so much, Sunny!