Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Joel Chua

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...