Hello! I have a table with two BY fields. Is there a way to get a total by the second field irrespective to the first? For instance:

TABLE FILE CAR

SUM SALES
BY COUNTRY
BY BODYTYPE
ON TABLE PCHOLD FORMAT HTML
ON COUNTRY SUMMARIZE
ON TABLE SUMMARIZE

END

Is there a way that I can get totals by BODYTYPE without considering COUNTRY? Or will I need to append a second table to the end of it? I'm envisioning 5 new lines somewhere around the grand total (Sedan, Coupe, etc.), with their respective sums.

Thanks!
Jay

This message has been edited. Last edited by: Jay Ervin,

Look at my answer at 1:46 pm from below post
SubTotal on multiple sort fields
This can be one way but I don't know all your requirements

quote:

Originally posted by MartinY:
Look at my answer at 1:46 pm from below post
SubTotal on multiple sort fields
This can be one way but I don't know all your requirements

I had tried a hold file technique like this, but I couldn't get it to work. Reading yours, I was missing both the blanking of the unnecessary field and the ranking to organize the lines. I can definitely work with this!

One last (hopefully quick) question... any suggestions on getting the word "COUNTRY" out of the subtotal lines (*TOTAL COUNTRY ENGLAND)?

Nevermind, I figured it out! I just added AS names to my summarize lines.

Thanks again for your help!