Skip to Content
0

Adding up group totals in crosstab

Mar 06, 2017 at 10:31 PM

65

avatar image

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:

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Abhilash Kumar
Mar 07, 2017 at 07:52 AM
0

Hi Fione,

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Fione Tang Mar 09, 2017 at 06:27 PM
0

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.


page01.png (56.4 kB)
page02.png (43.9 kB)
page03.png (7.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 11, 2017 at 12:59 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded