Row subtotals are more common than column subtotals
Prior
year 2020 2021
month 1 2 1 2
name location
Foo Loc1 58079 76576 0 83248
Foo Loc2 18497 85454 15339 62458
Foo - Total
Bar Loc3 76626 28186 17778 32187
Bar Loc1 8828 16128 17619 52834
Bar - Total
Desired
year 2020 2020 - Total 2021 2021 - Total
month 1 2 1 2
name location
Foo Loc1 58079 76576 0 83248
Foo Loc2 18497 85454 15339 62458
Foo - Total
Bar Loc3 76626 28186 17778 32187
Bar Loc1 8828 16128 17619 52834
Bar - Total
This should also be auto-generated when a pivot table is created with multiple columns i.e. year & month -> column subtotal vs year -> no column subtotal.