I would like to generate a report using across but would lik...

[Guest]

Interesting. Maybe someone will find something simpler, but this works.

DEFINE FILE CAR

ITASALES/P9 = IF COUNTRY EQ 'ITALY' THEN SALES ELSE 0;

END

 

TABLE FILE CAR

SUM SALES/D12

ACROSS COUNTRY

BY HIGHEST TOTAL ITASALES NOPRINT

BY BODYTYPE

END

 

 

image.png737304 19.2 KB

[Joel Chua]

Thanks David. That should work.

[Joel Chua]

I would like to generate a report using across but would like to sort from highest total for a specific COUNTRY.

Heres the code that I used:

TABLE FILE CAR

SUM SALES/D12

ACROSS COUNTRY

BY HIGHEST TOTAL SALES NOPRINT

BY BODYTYPE

END

Id like to sort this on the ITALY column (highest to lowest) instead of just the total sales for all the CAR file. Is there a way to do this

 

Thank you,

Joel