Making selection by clicking on text box

[Anonymous]

Colleagues, good day!

I have one small table with Sales data, Sales for checking data and difference between these two fields.

I have 3 text boxes counters, which show qty of ID with equal sales (green), almost not equal (red), almost equal (orange) and no data (Grey).

Is it possible to select ID by clicking on text boxes counters?

For example, if i click on Red counter, pivot should show me only records..

Thanks for advices.

There's test file and qvw in the attachment.

[antoniotiman · Accepted solution]

Hi,

see Attachment.

Regards,

Antonio.

[Anonymous]

Great!

Thanks a lot!

[jerryyang756]

Hi

You have to set a trigger on every color named Text Object.

Right Click on text object-> Action-> Add -> Select in Field Action

Now Insert the key field name in the Field area here it is --> ID

Now Insert the ID values for respective colors RED-2,4,6  into the 
Search String - (2|4|6) .

Please Check the attachment .

Please check the thread Set trigger to select multiple values in a field from a variable