Set Order for Summary Crosstabs & Chart Legends

Hello,I'm working with a text formula in my app that looks at a numeric field's value and formulates whether the score for a record is High, Medium or Low.

The formula is working fine, with the exception of how the formula's values (High, Medium, Low) appear in the crosstabs of summary reports and the legend in charts. By default QB alphabetizes it. This makes sense most of the time, but I'd like for the crosstabs/legend to appear in the order of High, Medium, Low.

In the past I've used a formula to add a "1", "2", "3", etc. to a Month field so they would show in chronological order, but would really rather not have any text before the High, Medium, Low values. Thanks!

I could be wrong, but I am pretty sure you can handle this in the field properties. Say you have a 'priority' field with the options listed as High, Medium, Low and field is set to display the options alphabetically. It will display them as High, Low, Medium. However, if you sort the options in they way they are shown in the field, and order them top to bottom = low to high, your report would probably conform. Let me know if that works. #nocoderequired

I have a similar question to this one. I want to change the sort order (from Ascending to Descending) in the crosstabs of a summary report. The fields that is being used in the crosstabs is a percent field. I want the highest percent to show up first. I've tried changing the sort order in field properties which has no impact.

I've tried creating a formula field and adding spaces before the percent (such as below) but it still sorts ascending. If([text]=0.25, ".25",[text]=0.5, " .50",[text]=0.75, " .75",[text]=0.9, " .90")

When I add unicode characters, the % then changes to zero. For example:If([Text]=".25", "&#8289; .25" shows up as 0% in my table.