Question on Grouping

System

This discussion was created from comments split from: Introducing a new report builder plus grouping and summary for reports.

Natalia Kataoka

Question on Grouping - I am grouping by a dropdown menu, but the way the group displays is in alphabetical order, not the order of the drop down. Is there a way to group by the dropdown's original organization?

Versus

Also, can we no longer filter source sheets by name?? I have over 6000 sheets in the workspace I work out of but that creates too many sheets to properly group. And, since we have the same column names in different types of sheets (like Assigned To), I am pulling in sheets to my report that I do not intend.

SoS | Dan Palenchar

In my experience with this new feature it is alphabetical, the most obvious/easy workaround is to number your options but of course this will break once you hit 10, so you could precede each option alphabetically.

*a. Option 1

*b Option 2...

etc.