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?