How to permanently exclude undesired data in pivot table filter after table refresh

How do I permanently exclude unrelated criteria in my Travel pivot table when I refresh it? Every time I refresh the table, other categories/descriptions and related amounts appear in the results. Then I have to repeatedly deselect these categories or descriptions to show only travel-related criteria and amounts.


The first table below refers to general transactions used to create the Travel pivot table which is displayed below it.

Posted on Nov 26, 2025 9:12 AM

Reply

There are no replies.

How to permanently exclude undesired data in pivot table filter after table refresh

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.