5 Replies Latest reply: Nov 30, 2011 1:46 AM by Dinesh Kumar RSS

    Input box based on expression column

    Dinesh Kumar

      Hi all,

      I have a Pivot Table and I want to have the ability to choose Area or Country with minimum change in sales i.e Diff. For example, user can enter values (Diff values)in the Input Box  and only corresponding countries  should reflect in the chart. How to trigger the vaible in the Input box to relate to the values in Diff Coulnn? How this can be achieved. If a user is entering ">200" in Input box, only Hungry should be shown. Please refer to the below sample example.

       

      prob1.jpg

       

      Let me know if any staright method/workaround is available for this. Thank You in advance.

       

       

      Regards,

      Sharma