Skip to Content

Adding up group totals in crosstab

I'm putting together a crosstab and need to insert a grand total by adding the first 3 group's subtotals (all short-term investments groups) together and place this grand total right under the 3rd group's subtotal. How do I go about referencing the subtotals that are automatically generated by the crosstab which has no GridRowColumnValue? After Insert Row, I ended up having the grand total before the 3rd group's subtotal instead. Any help would be greatly appreciated. Thanks.

Please see sample below:

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 07, 2017 at 07:52 AM

    Hi Fione,

    Would you be able to attach the report 'with saved data' please?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09, 2017 at 06:27 PM

    page01.pngpage02.pngpage03.png

    I'm not sure if you meant to attach the report in .rpt format, if so, I cannot. My attachment must be one of: txt,xml,gif,png,jpeg,jpg,jpe So I'm attaching the full report in .png format instead.

    What I'm trying to achieve is to put a subtotal for all the "Short-term Investments" groups together, then another subtotal for the result of all Short-term Investments plus "Held in Trust for Curr Debt Svc". And finally a grand total to include all groups, which I think can be done by the crosstab itself if I select to display "Grand Totals". If not, please advice on how to do that as well. Thank you in advice for your expertise advice.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2017 at 12:59 PM

    Hey Abhilash,

    I have crytsal report showing bank details with summary page at the end; I have used crosstab for creating summary pg and i have calculated fields in the crosstab (Difference of 2 fields as 3rd field). For the 3rd calculated field i am getting incorrect totals. can you help with me with the formula for calculating totals for 3rd field?

    Add comment
    10|10000 characters needed characters exceeded