Advanced Sort Problem

[#1]

Hello everyone. I'd like to thank you all in advance for your help.

I've been having some trouble sorting my data the way the end user wants it. Basically there are several priorities while evaluating customers. Instead of sorting them from biggest to smallest, I have to sort them by net sales first, then by net volume, then by punctuality in delivery and so on.

The question is how could one do that, while showing the data in one simple chart?

Any help would be greatly appreciated!

Cheers,

Josué C.

[Anonymous]

Have you tried to sort the dimension with an expression? something like:

=max([Sort 1])

or

=rank([Sort 1])

[colinh]

Hi

The best way to do this is probably in your script, by creating a table for sorting. So create a table something like this:

SortOrder:

load RowNo() as Order,

Concept

resident Table //whatever your table name is

order by [Sort 1] desc,[Sort 2] desc,[Sort 3] desc,[Sort 4] desc,[Sort 5] desc,[Sort 6] desc,[Sort 7] desc;

Then in your chart sort by Expression, using the expression =Order.

That gives me a bar chart sorted Customer 2, 6, 10, 9 etc, as in your table box.

Hopefully this will work with your actual data.

Colin.

[prieper]

I do not know, how to capture the sort-order in the table, but you may use a variable to either determine the display in the graph or only determine the sorting-order.

See the attached example

HTH
Peter