Burning some brain cells...
So I've previously used the following website to create a top 10 and all others views. It has worked perfectly!
However, now I want to create the same view but adding sub-categories in which it would display the top 10 and various for each sub-category.
Any ideas on how to change the formulas in this link to address this issue?
Without having a look at your workbook, it's difficult to provide specific advice.
However, what you need sounds like a context filter.
Here's a post of great discussions for your reference.