Hello @haythoo, if the SQL statement update that @todd.hoffman suggested isn’t the route you want to take, you could try utilizing the LAC-W function sumOver() that is built into QuickSight. This allows you to sum the amounts by category and year groupings as the partition level.
I will mark this as a solution for now, but if you have any follow-up questions on implementing the calculated field please let me know!