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

Summary or Running Totals HELP

Status
Not open for further replies.

Darrick

Technical User
Aug 28, 2001
77
US
I have a report with 2 different groups. I'm suppressing one of the groups based on the count value of a field.

I'm trying to add a grand total for only the numbers that are shown on the report. For example I may have a grand total of 50,000 (Including all of the suppressed fields), but I only want to see the 25,000 in my grand total which is not visible. Any Ideas?

Thanks in advance,

Darrick
darrick3@yahoo.com
 
Hi,

Try creating a running total (count type} with update formula which will be the opposite of your group suppression formula

Hth,
Geoff

 
I've tried creating a running total, however it won't let me create one. It keeps giving me an error that it cannont create a summary/running total.

Any other ideas?

Darrick
darrick3@yahoo.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top