I'm using the new Pivot Table functionality and seems to be exactly what we needed!
The issue is that when the row is not grouped (more than one row for the field) on Pivot Table a subtotal is not generated making the grand total wrong as it only sums when a group subtotal was formed and ignores all other values or rows.
Example:
Texas - 2019 -- 2 sales
Texas - 2020 -- 3 sales
Totals for Texas ---- 5 sales
California - 2020 -- 3 Sales
Grand Totals ---- 5 sales
Expected:
Texas - 2019 -- 2 sales
Texas - 2020 -- 3 sales
Totals for Texas ---- 5 sales
California - 2020 -- 3 Sales
Totals for California ---- 3 sales
Grand Totals ---- 8 sales
on the first post