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

[Brent Mason 2]

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.

[David Beagan]

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

[Brent Mason 2]

Ah, I knew I was close, but I just couldnt figure out the last step.

I greatly appreciate your prompt feedback and expertise. Ive learned a lot just by studying the code you developed for our custom portal in 2018-2019. Thank you.

[David Beagan]

Thanks Brent. Im happy to hear you are still using it.