Sorting on Column in straight table

[Anonymous]

Hi All,

         We have a straight table and has multiple columns.

         1. Sales value

            Expression:

= if($(sales)>=1000000000 ,NUM($(sales)/1000000000,'$#,###.0B'),

    if($(sales)<1000000000 and $(sales)>=1000000, NUM($(sales)/1000000,'$#,###.0MM'),

                                        NUM($(sales)/1000,'$#,###.0K'))

           )

       2. Other columns

We kept sorting on the sales column.This works fine when we have all thee vlaues in one group either B or MM or K. when mixed group comes up we this sorting does not work. Is there any way I can sort all in the raw sales data and use that for sorting instead of display column?.

Sales	Previous Day Change	Net Change	Actual Sales
$100 K	1%	0.25%	100000
$98 B	2%	0.25%	98000000000
$3 M	3%	0.25%	3000000

[#2]

Yes. You can sort by expression.

Just set expression = sum(sales).

Also, Why the if/then with the num function? On the Number tab there is a space for Symbol, Thousand Symbol, Million Symbol, Billion Symbol - you can use these and it will take care of the formatting for you without having to break it up.

[Anonymous]

Sort column expression is disabled. Is there any way I can enable it?.

[#4]

Hmm. I don't know! I haven't seen that disabled before.

User Preferences - Design - Default Styling Mode = Advanced, maybe?

Or Document Properties - General - Styling Mode = Advanced?