1. TARGIT Community
  2. Community
  3. General Discussion
Knowledge Base

Grand total based on subset of rows

Thomas Ejlerskov ·

Hi Targit 

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

Thanks.

/Thomas

 

  

0

Comments

1 comment
Sort by DateVotes
  • Ole Dyring

    Hi Thomas,

    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:

    sum(d1, @"";"[2020]"(l(0,1)), m1)

    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

    0
Please sign in to leave a comment.