Focal Point
Holding Subtotal in a file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8911028331

December 24, 2004, 11:07 AM
thangam
Holding Subtotal in a file
Can I hold columnwise subtotal in the hold file?
December 24, 2004, 04:03 PM
GCohen
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