doing annual living expenses but after using subtotal sort need % of subtotals

I'm just a guy trying to get his 2019 annual living expenses down into a spreadsheet

I've inputted all the data from my Checking account and credit cards. I sorted by Master Category and subcategory to see the subtotals of my spending.

Now I need a way to see how my subtotals look as a percentage of the grand total - while still keeping my document in the SUBTOTAL view mode. Is there a way to do this?

See attachment for simple example


THx, bob

This in D2 and dragged down ? seems too simple so I might no understand your problem

Please Login or Register  to view this content.

and formatted as %

Are you looking for a % of Sub vs Master and Master vs Grand?
Try % of sub & Master
D2:

Please Login or Register  to view this content.

% of Master vs Grand

Please Login or Register  to view this content.

Drag both down

Capture.PNG