24 Replies Latest reply: Aug 24, 2012 9:25 PM by nicole00 RSS

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

      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!!!!