My earlier solution should give you exactly the numbers you asked for. It won't say "Total" because that wasn't part of the original problem, but that's easy to accomplish by making three changes: where X_Class1 ne 'Total'; (where=(X_Class1 ne 'Total')) X_Class1='Total'; Notice that ne : has become ne. If you're getting output that is not what you want, post what changes you would like to see. Good luck.
... View more