Filter Pivot Table Based on Values Entered in Inputbox

[#1]

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 :

EmpID	Last Name	First Name	Title	Hire Date	Office	Extension	Reports To	Year Salary	Age	Experience
24	Crawford	Judy	Systems Manager	06/08/05	1	200	19	50400.00	45	20.7
1	Roll	Frank	Sales Representative	10/01/03	2	501	4	61000.00	35	10.3
2	Presley	Erik	President	09/14/03	1	101		180000.00	49	28.8
3	Carsson	Rob	Sales Representative	10/01/04	5	102	4	63000.00	27	4.8
9	Brolin	Helen	Sales Representative	02/15/07	1	103	4	60000.00	29	5.7
42	Ärlig	Östen	Account Manager	12/24/03	1	104	3	51000.00	26	3
52	Ashkenaz	Mike	Account Manager	11/30/04	1	-	42	49500.00	24	1.2
7	Lindwall	Tom	Sales Representative	02/22/07	2	201	4	61000.00	28	3.5
8	Shine	Leif	Sales Coordinator	03/05/04	2	202	2	65000.00	38	13

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.

[Anonymous]

Your attached application seems to do what you want it to. Currently it seems to display the rows if at least one of the conditions is meet. If you want it to reduce based on all of the conditions you will need to include all three tests them all three expressions. You should be able to reference Column(ColumnNo) though when doing this.

Jonathan

[#3]

Hi jonbroughavone ,

Can you please explain with any example ?

Thanks

[manideep78]

Hi Kiran,

I have done this with the help of a button object.Please checkout the attached qvw file and let me know whether it satisfied your requirement or not.

Thanks,

Manideep

[#5]

Hi  Manideep,

Appreciate your work.

You have used button to filter out table but what if user wants to see all the data?

,what I needed is ,after entering values in all the input boxes,only related data should be displayed.

Thanks.

[manideep78]

Please find the enclosed file.

Thanks

[#7]

Hi Manideep,

Thanks for reply.But I am looking for something else.

[#8 · Accepted solution]

Hi All,

One of my collegue gave the solution & its working as per the requirement.

Thanks all for valueable efforts.

Please find attached qvw file for correct solution.