Add another Total on Crosstab

[alfie1109]

I would like to add a Grand Total at the end of the report (Sum of Total), but not sure how to go about on doing these using Crosstab.  Below is an example of what my report looks like right now (minus the Grand Total at the end).

 

Region Florida
	Beer Btl	Beer Draft	Beer	Beverages	Food	Liqor	Totals
1 - Tavern Lake	207.10	268.45	333.00	172.00	1666.92	649.25	3296.72
2 - Tavern Park	154.25	587.45	295.80	139.20	1422.18	476.00	3074.88
Totals:	361.35	855.90	628.80	311.20	3089.10	1125.25	8087.36

Region Georgia
	Beer Btl	Beer Draft	Beer	Beverages	Food	Liqor	Totals
1 - Tavern Heights	142.20	135.95	196.25	182.45	1603.15	463.50	3217.00
2 - Tavern Court	149.00	181.00	302.50	156.00	1733.87	525.00	3299.12
Totals:	291.20	316.95	498.75	338.45	3337.02	988.50	6516.12

 

Now, I want to add the Totals of both Regions for each column.  How do I go about on adding a new row for Grand Total?

 

	Beer Btl	Beer Draft	Beer	Beverages	Food	Liqor	Totals
Grand Total:	652.55	1172.85	1127.55	397.71	3822.85	988.50	14603.48

 

Any help is very much appreciated!  Thank you!!!!

 

~a

 

 

 

[alfie1109]

Problem solved!

Added another Crosstab in the Last Page footer, based on Regions.