How to create drill-down matrix hierarchy with pre-aggregated data without double-counting?

I have a pre-aggregated dataset from an agency where each hierarchy level has its own row with pre-calculated values: Category Total = 158,244 Sub-category = 45,000 Brand = 11,804 SKU = 350 Th...