Is it possible to subtract subtotals in a crosstab?

[padigela]

I've a cross tab with two groups on the left side.I wonder if it is possible for the grandtotal to be the difference of the 2 subtotals(subtot1-subtot2) rather than sum of them, as it does usually. Pl note the values can be negative or positive.
Any ideas??
Thanks for your help!

 

[IdoMillet]

No such built-in option.

Try to Suppress the Grand Total row in the CrossTab
and insert a second section below with a CrossTab
summarizing a formua returning the difference.
Same column grouping, but no Row grouping.

Never tried this, but I think it should work.

hth,
- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm