Sorting of two expression in straight Table

[Anonymous]

Dear Experts,

Can I sort two expressions at a same time in Straight Table?

If yes, then how?

Pls suggest.

Regards,

Balraj

[maxgro]

if you want to sort by exp1 and exp2,

first click on exp2 label and then on exp1 label

[#3]

Hi,

You can use Promote/ Demote options in the expressions tab to sort your expressions (exp1/exp2)

Thanks

Charitha.

[Anonymous]

Did not get you.....

Say, I am having two expression Expr1 and Expr2.

How I can do it in straight table??

In Sort tab, I can promote only one expression not all!!!

[maxgro]

- in chart properties there is a sort tab

you can choose how to sort fields (using promote/demote) and sort by;

unchect "Allow Interective Sort";

in this way you can sort by 2, 3, .....n fields; the sort is static, not interactive (flag unchecked)

- or if you want to do an interective sort by n fields (field1, field2, ...., fieldn)

check "Allow interective Sort"

start sorting from the last field (fieldn) clicking on his label, then sort field-1 (click on label), then .... until field1

[#6]

can you elaborate what you are expecting exactly by an example.

[mdmukramali]

Dear,

I think may be he is looking sorting should be like this??

Load * inline

[

Coutry,Sales,profit

India,2400,1000

US,2500,1200

AUS,2400,1200

SA,2600,800

NZ,2600,1200

]

;

sales are sorted and based on the sales he want to sort the Profit (1200 ,1000)

i don't know how to achieve this??

[#8]

Yes, as per my understanding one column (Sales) has been sorted manually, as well as Profit should be changed

as per the sales.

i think if we changed one column in the chart automatically others will reflect as per the user selection .

what do say ?

-Charitha.

[jagan]

Hi,

You can set the priority of Sort, Promote Exp1 to the top and Exp2 to the second position.  Now the charts initially sorts by Exp1, and then sorts by Exp2.

Hope this helps you.

Regards,

jagan.

[#10]

yes i agree with this.