7 Replies Latest reply: Feb 12, 2013 12:57 AM by Kiran Shinde RSS

    Filter Pivot Table Based on Values Entered in Inputbox

    Kiran Shinde

      Dear All,

       

      I have one pivot table which should be filter based on values entered in Inputbox.

      Below is one sample Table I have taken from which Pivot Table is created.

       

      Snapshot of Excel :

       

       

      EmpIDLast NameFirst NameTitleHire DateOfficeExtensionReports ToYear SalaryAgeExperience
      24CrawfordJudySystems Manager06/08/0512001950400.004520.7
      1RollFrankSales Representative10/01/032501461000.003510.3
      2PresleyErikPresident09/14/031101
      180000.004928.8
      3CarssonRobSales Representative10/01/045102463000.00274.8
      9BrolinHelenSales Representative02/15/071103460000.00295.7
      42ÄrligÖstenAccount Manager12/24/031104351000.00263
      52AshkenazMikeAccount Manager11/30/041-4249500.00241.2
      7LindwallTomSales Representative02/22/072201461000.00283.5
      8ShineLeifSales Coordinator03/05/042202265000.003813

       

      Snapshot of Pivot Table :

       

       

      Now when user wants to filter data where Annual Salary is between 45000 - 50000 then I have provided two input boxes where user will enter

      Salary = 50000 with tolerance 5000 ( this provision is as per client's requirement).

      Similar provision is needed for filtering data further on Age & Experience basis.

       

      So how can I do this? Can anybody help me in getting this ?

      Thanks

       

      PS : I have attached QVW as well as Data source for your reference.