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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page Totals in Crosstabs

Status
Not open for further replies.

SIGBO

MIS
Nov 14, 2000
14
GB
I am trying to get Page Subtotals working on a Crosstab.

I can get them to work in Ordinary tables by following the instructions in the manual, but in Crosstabs it just gives the REPORT total in each page.

Any thoughts would be appreciated.
 
Hello Sigbo,

Try the context "in block" to calculate subtotals within a crosstab.

blom0344
 
Thanks for the tip, however it did not give the desired result.

While e.g.
Sum(<Field>) will give the total for that crosstab column in the WHOLE report.
Sum(<Field>) in Block gives the total for EVERY field in the WHOLE report.

What I need is the total for that crosstab column in that page which can be done in an ordinary table by using.
Sum(<Field>) in CurrentPage.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top