Grand total based on subset of rows
I have a simple crosstable with amounts per account per year (2020, 2021 and 2022).
I want to create a seperate calculated column that gives me the grand total for 2020. Is it possible to make this calculation? The yellow column demonstrates what I want to achieve:
63+16+12 = 91