Straight chart order by expression

[#1]

Afternoon All,

I have a straight chart I am using to display a reconciliation between 2 sources. I would like to have the chart ordered by the size of any differences in the 2 sources. So for my dimensions I have Date, Account, Currency and for my Expressions I have:

Sum(SourceA)

Sum(SourceB)

Sum(SourceA) - Sum(SourceB) (Label: Diff)

fabs(Sum(SourceA) - Sum(SourceB)) (Label: AbsDiff)

And on the Sort tab I have select Sort by Expression, Descending, with this as the expression:

fabs(Sum(SourceA) - Sum(SourceB)) (Label: AbsDiff)

But it doesn't appear to be sorting the data at all! What am I doing wrong?

TIA,

Tony

[#2]

Have you switched on the checkbox for override group sort order?

If you haven't, switch it on and try again.

[#3]

That checkbox is greyed out for all columns in the Priorty list.

I think I've got round it by promoting my AbsDiff field to the top of that Priority list and then just sort descending on it. However, idelly i'd like not to display this field (AbsDiff) but just use it for the sorting.... Do you know if I can do that?

Thanks for your help,

Tony

[#4]

I seem to remember that this becomes greyed out when the other checkbox (allow interactive sort) is either on or off, so try checking/un-checking that box to see if the override sort order becomes available.

[#5]

Nope, the checkbox is greyed out whether Allow Interactive Sort is checked or unchecked.

In the help file it says Override Group Sort Order "is only available when a group dimension is selected in the Priority list ", but I'm not sure what a group dimension is. I don't think I'm using them.

The sorting is working now and I've managed to hide the column from the Presentation sheet.

Thanks,

Tony