Yes. You can do a rollup at the subcategory level, then another rollup again at the main category level.

Hi Paul! You can structure this by doing the following: Create a new field called ‘Main Category’ on your subcategories table that links to the main categories table. When doing this, specify that each subcategory can only link to one main category ...