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

Using legacy metadata sample ggsales, I want to sort Doll...


Brent Mason 2

Recommended Posts

Using legacy metadata sample ggsales, I want to sort Dollar Sales by Region and then by State within each Region. The result should be the following:

 

Ive tried several approaches, including WITHIN and with/without multi-verb requests. Heres what I currently have:

TABLE FILE ggsales

SUM DOLLARS/P21MBC NOPRINT

BY TOTAL HIGHEST DOLLARS/P21MBC NOPRINT

BY REGION

 

SUM DOLLARS/P21MBC

BY TOTAL HIGHEST DOLLARS/P21MBC

BY REGION

BY ST

END

 

Id appreciate the communitys input. Thank you.

Link to comment
Share on other sites

This seems to do it.

TABLE FILE ggsales

SUM DOLLARS NOPRINT

BY TOTAL HIGHEST DOLLARS NOPRINT

BY REGION

SUM DOLLARS/P21MBC

BY TOTAL HIGHEST DOLLARS NOPRINT

BY REGION

BY TOTAL HIGHEST DOLLARS NOPRINT

BY ST

ON TABLE SET BYDISPLAY ON

END

 

There is an extra BY TOTAL HIGHEST solely to avoid the error:

(FOC020) THE SETS OF SORT PHRASES ARE INCONSISTENT

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...