Filtering on pivot table calculated fields:
Click on the row beside the last row:
Click on Filter
The following should appear
Filtering is available for all fields that are calculated in the pivot table.
Welcome to the Financial Spreadsheets & Reporting Help Center
Find answers fast: Ask a question, search for keywords, or explore articles below.