Sorting a Percentage Decending

[Katie Sikorski]

I have a percentage column and I want to sort it descending order from high to low by color. When I select the column and go to Column Properties and choose my percentage the sort is greyed out. Is there no way to sort a number descending order on a chart Does it only sort text See attached Example

 

Please let me know

 

Thanks,

[Kirsten Smith (she/her)]

You cannot change the sort order of numeric or datetime columns. What you could do is create a new column using something like String([Pct column]) to make it a string column, at which point you could use Custom Sort Order to put the values in the desired order.

[Katie Sikorski]

Ok thanks so much i will try that