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
You will need to work with "Multidimensional subtotals".
First, you enable these from the right click menu:
This will bring in subtotals for the years in your crosstab that you can refer to.
You can refer to your 2020 values like this:
Finally, you may want to go to Visibility options to hide the year subtotals.
There is a video example here: https://community.targit.com/hc/en-us/articles/360017917778-Multidimensional-Subtotals
BR / Ole
Please sign in to leave a comment.