How to automatically get sub totals

I would like to have sub totals show up automatically for each category when sorted by category.

Are you referring to any specific sheet - like the Transactions sheet?