I'm trying to look for a way to display the total lines per group by. XX marks the placeholder for that count value (CNT.DEALER_COST). CNT.DEALER_COST is not a displayed field and there is a requirement to have it place on a location in the SUBTOTAL. I appreciate all the help.

TABLE FILE CAR
SUM
DEALER_COST
BY COUNTRY
BY CAR
BY MODEL

ON COUNTRY SUBTOTAL AS 'Total: XX Lines for '
ON TABLE NOTOTAL
END

Thanks,
Dan

This message has been edited. Last edited by: Kerry,

Dan, the simplest way to achieve what you want is by using SUBFOOT and some spotmarkers to position your results.

There could be a way to simulate it with SUBTOTAL but it would require a more elaborate approach and I don't know if that is entirely feasible.

This message has been edited. Last edited by: njsden,

In addition to my previous post, even if you managed to put that content in your SUBTOTAL you'll be facing the issue of trying to keep the "Total: XX Lines for" message along with the actual totals in the same line and that is tricky business!

Thanks njsden. I'll give SUBFOOT a try to be able to move the fields around.