I am assuming Blue as Y and Orange as N and calling this field as Status
1) Create a calculated field name it as sorting
2) Place this sorting field in between Division and [Department/program] and Uncheck show header
you will get sorted values
Hope this helps
Replicates same with Superstore its working fine
Plz mark this answer as correct or helpful to close the thread
This worked perfectly!! I am still learning my way around using the Fixed function, which I know is primarily learning how dependent they are on filtering (i.e. making sure to add them into the calculation).
I really appreciate your prompt response on this! Have a great weekend.