after a GroupBy , Sort by column question

[MTS]

i am working with Movie data, and did a "Group by" category, within each category is a movie title.... right now the title are NOT in alphabetical order.... IF i add a Sort tool after the Group by.... it sort the original file alphabetically, completely ignoring the Groupby...

After a Group By, what is proper way to Sort a details column  of the Group By

(i feel there is an "order of operation" within Alteryx, that I am not getting... this type of behavior isn't the first time.)  thanks for any insight

[Qiu]

@MTS 
We can set multiple columns for sorting. in you case, the first should be Group by, then follows by Title, I believe.

[ncrlelia]

Hi @MTS,

If you are using the Summarize tool for your 'GroupBy' action, you can also achieve the sorting result (shared by Qiu) by adding another layer of GroupBy for the Title in the Summarize tool.

Input data

Output of Summarize Tool

Hope this helps.

Cheers,

Lelia

[MTS]

both solutions worked.  thank yyou

[ncrlelia]

Hi @MTS,

Happy that we are able to help.

It will be great if you can accept our solutions. 
Thank you.

Cheers,

Lelia