Hi
I want to be able to only show rows in a pivot table where a certain criteria is met. I don't want to use list boxes or any other filter that affects the whole sheet, I only want it to effect this pivot.
Example data below I would only want to see the product if the Tlevel is less than the Clevel.
| Product | Tlevel | Clevel |
| 123456 | 1 | 5 |
| 123457 | 2 | 4 |
| 123458 | 3 | 3 |
| 123459 | 4 | 2 |
| 123460 | 5 | 1 |
Is this possible?
