Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have a calculated column called brand_status that calculates a store's engagement with a brand based on recent order behavior.
The statuses are "Activated" "In Activation" "Needs Reactivation" "Sampled"
Is there a way to define the sort order for these items so that I could sort the records based on something other than alpha or numeric?
Operating system used: MacOS Monterey v12.4
Hi,
I don't think there's a direct way to do that, however, you can use Switch case processor to set a numeric value in a new column for any possible value ("Activated" "In Activation" "Needs Reactivation" "Sampled").
Once you have all possible values configured, you can use this new column as sort column.
BR,
Álvaro