-
1. Re: Several action filters on one target sheet, including multiple dimension per source sheet
Jim DehnerJan 3, 2018 5:31 AM (in response to Thijs Jahae)
good morning
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
Jim
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.
-
2. Re: Several action filters on one target sheet, including multiple dimension per source sheet
Thijs Jahae Jan 3, 2018 6:13 AM (in response to Jim Dehner)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.
Great
-
3. Re: Several action filters on one target sheet, including multiple dimension per source sheet
Jim DehnerJan 3, 2018 6:18 AM (in response to Thijs Jahae)
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
Jim