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.