I'm having a similar issue.I can do the rollups on another table, but I can't figure out how to sum across years (as records) down a *single* vertical column (field). Instead, I still end up with 2023 rolled up in one column/field, 2022 rolled up in ...
I'm wondering if anyone has found a solution to this? I'm sorting based on the column (field) header, then trying to assign the same value to the remaining empty cells. But when I change one, it of course jumps to it's new position based on alpha ord...