Excel Filters – show only relevant values in the filter

Try to to click right mouse on the table and choose PivotTable options, then go to ‘Data’ tab, and then choose ‘None’ under: Number of items to retain per field. i think this should solve the problem.