joeymonts18
New Member
- Joined
- Sep 13, 2016
- Messages
- 4
I am looking to use the number entered in a cell as the "greater than or equal to" value filter for my pivot table values "Order History" and "Percent Difference."
I only want to see entries where Order History is greater than cell F3 AND the percent difference is greater than cell F4. However, I need to be able to change these numbers as different groups have different parameters.
The workbook is attached and any help is greatly appreciated!
Sheet3
Pivot Table Name: PivotTable1
Order History Variable Cell: F3
Percent Difference Variable Cell: F4
I only want to see entries where Order History is greater than cell F3 AND the percent difference is greater than cell F4. However, I need to be able to change these numbers as different groups have different parameters.
The workbook is attached and any help is greatly appreciated!
Sheet3
Pivot Table Name: PivotTable1
Order History Variable Cell: F3
Percent Difference Variable Cell: F4