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", "⁡ .25"
shows up as 0% in my table.
Any suggestions?
