Trying to sort by the first column in Across values. For example:

TABLE FILE CAR
SUM
     SALES
BY CAR
ACROSS HIGHEST COUNTRY
END

Try to sort that list by ascending values of W Germany Sales, not by Car.

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

Perhaps this will work:

DEFINE FILE CAR
SALES_WG/D10 = IF COUNTRY EQ 'W GERMANY' THEN SALES ELSE 0;
END

TABLE FILE CAR
SUM
SALES
BY TOTAL SALES_WG NOPRINT
BY CAR
ACROSS HIGHEST COUNTRY
END

The TOTAL is important as that is the value shown on the report, without TOTAL you'd get multiple lines per CAR because there are multiple models per CAR.

(Don't have a clue why "SALES" shows up as a column title for each ACROSS column)

aha. I used exactly the same approach but was missing "TOTAL". Let me try it.

That's got it. Thanks!

Well, dang. In my specific case the value being summarized is a text value. BY TOTAL TXTVALUE gives me blanks.

let's work with an alpha field then:

DEFINE FILE CAR
RPMX/A5 = EDIT(RPM);
RPMX_WG/A5 = IF COUNTRY EQ 'W GERMANY' THEN RPMX ELSE '';
END

TABLE FILE CAR
SUM
RPMX
BY TOTAL RPMX_WG NOPRINT
BY CAR
ACROSS HIGHEST COUNTRY
END

What's wrong with this picture?

well, not sure. it works with CAR file, but not my datasource. guess the problem is on my end somewhere.

Still no success with this, but it works with the CAR file, so the problem must be something else.
SOLVED.