not certain I understand what you are doing but see the attached
The Category filter was not applied to the year and month worksheets
see the process below
if will return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks! This indeed resolves the problem.
Somehow by default the action filter does not incorporate the categories into the other sheets. I don't know why this is the case but in the sample workbook and in the workbook I am using myself this solves the problem.
Glad to help out
there are more than one ways to apply filters to other sheets - the one I showed is the most direct - I like to use it when I can