IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Holding Subtotal in a file
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Gold member
Posted
Can I hold columnwise subtotal in the hold file?
 
Posts: 77 | Registered: December 22, 2004Reply With QuoteEdit or Delete MessageReport This Post
Platinum Member
Posted Hide Post
The easiest way to display a subtotal in a file is to use two sentences. The first gets the total for the main sort field, and the second gets the details that were summed. e.g.
TABLE FILE CAR
SUM RCOST
BY COUNTRY <- The totals for Country
SUM RCOST
BY COUNTRY BY CAR <- the detail by Car
ON TABLE HOLD
END
 
Posts: 197 | Registered: June 08, 2003Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Holding Subtotal in a file

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.