Quick way to duplicate subtotals to higher levels

Worksheet Operations
#1

Is there a shortcut/easy way to add the subtotals to higher levels. I.e. I have sales total in level 1 by product and I want to sum that up in level 2 by brand. or is it just creating a new metric

i have like 20 metrics so just wondering if there was a quick shortcut that i wasn’t aware of

#2

Sure, you can just duplicate the sum formula in level 1, then drag it to level 2. That will keep the logic of the formula, but it will aggregate at the level where it resides.