How to link input box with predefined values to an expression in a pivot table?

[#1]

A sample file is attached but I am not sure what I need to do...help me please??!!???!!!?

1. I need to know how to link an input box with predefined values (All; 0%; 50%; 80%; 100% or more) to an expression (% Expended) in a pivot table

All - shows all records regardless of % Expended

0% - shows records that have % Expended equal to 0% or is null

50% - shows records that have % Expended equal to 50% or more

80% - shows records that have % Expended equal to 80% or more

100% or more - shows records that have % Expended equal to 100% or more

2. Last thing I need to do is clear the input box selection and make it default back to All.

Any guidance or assistance would be greatly appreciated!!!!

[sebastiandperei · Accepted solution]

When do you created the trigger? I haven't found it.

So, you changed the expression for make it at the begin. Now, we have a field that makes the filter function.

The variable will only "trigger" the selection on the field Show...

I've modified all these concepts, and attached the document again.

[#3]

Sorry, I attached the wrong file. 

This is great, thank you so much for your assistance!!!!!!!!!!!!!!!!

[#4]

Sebastian,

Can you take a quick look at my file and tell me what I am doing wrong with my input box?  I created a new file based on a different grouping.  However, my input box is not working?  I added my trigger and created the variable but the data is not linked to the table????

[sebastiandperei]

The data is linked, you see that where you select a value in PercentageExpended, the table shows you only their values.

I think that the problem is the name of the field, with this char (I can't find it in my keyboard!)

So, you must put the triggers in Change value (look at the last app I've sent)

[#6]

I did try that and I was still not able to link to the file. 

But, I finally did after I made the "Variable1" all lower case in the trigger.  Who would have known, but thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!