Thank you for the help.
I feel like we are really close to coming to the resolution on this; however, we are not quite there.
I followed your instructions and applied the same logic to my actual sheet and I need some follow-up help.
The set you created, "Set 1", manually filtered certain Sub-categories, while I need the Top 10 to be dynamic. When I remove the manual filter on the set, I'm still running into an issue. I would like to sort by each month and quarter individually and have the Set then update the Top 10 -> meaning on some months certain products will be included in the Top 10, and others will not be included in the view.
See my tab called "Month 2". Here I'm sorting on June 2014. The Top 10 sub-categories would be the following:
However, following your process on tab "Month" the sub-category "Copier" is included even though the sales were $0. How can I adjust the Set and/or the Top 10 filter so the actual top 10 is shown (like the chart above) when filtering on a particular month?
Sort set (2).twbx 1.2 MB
Glad I could help out. Thanks for the "Awards". Much appreciated.
Have a nice one.