Add filters to pivot table

[ronarosario]

[FONT=&quot]Hello,[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I need help on this. I have a pivot table with the following columns:[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Manufacturer Name MPN Commodity Family Project Name Contract Manufacturer Unit Material Cost Volume Spend[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I want to add filters above the table so it will look like this.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Enter price: (select greater than, less than, equal to) <Unit Material Cost drop down list>[/FONT]
[FONT=&quot]Enter spend: <choices>[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Manufacturer Name MPN Commodity Family Project Name Contract Manufacturer Unit Material Cost Volume Spend[/FONT]
[FONT=&quot][/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]My idea is that users can enter any price or spend (let's say greater than $10 price and $5000 spend) and a table with the information same as above will display.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I've tried the following:[/FONT]
[FONT=&quot]1. Add fields twice in the pivot table - not possible[/FONT]
[FONT=&quot]2. Add slicer - difficult to filter as I have to select prices one by one (particularly for those that should be greater than or less than).[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Any thoughts on how I can do this? Your help is greatly appreciated.[/FONT]

Rona

 

[ronarosario]

Any help pls?