Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can the grandtotal of a crosstab be the difference of group subtotals

Status
Not open for further replies.

padigela

Programmer
Jun 26, 2002
2
US
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!
 
Not to my knowledge. Do you think you can get away with suppressing the Column Grand Totals in the Format Crosstab | Customize Style tab (or just suppressing the grand total lable and field cells) then inserting a formula in a section below the crosstab that works along these lines:

Sum(amount, row1) - Sum(amount, row2)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top