Set Order for Summary Crosstabs & Chart Legends

But where is the Mongolian Vowel Seperator?

Hi Eric, This is a formula field I'm dealing with so I don't think I can apply that method.

I am diving deep into my automatic memory here, but I believe that the order of true values in your formula will dictate the low to high order.

For example, if your formula looked something like this:

if([this thing]>100,"High",
if([this other thing or the same thing]<=50,"Low","Medium"))

your low to high order would be High, Low, Medium.

if it is possible to change your logic to put them in the correct order, this would probably work. 

I'll test to double check.

I was wrong about that. dang! 

Here is what I have resorted to in the past:

If([# of Tasks]>6,"1-High",
If([# of Tasks]>1,"2-Medium","3-Low"))

Not sure if that is helpful. Looks like Dan the man was on the right track. Best of luck to you!