Sort order on calculated column

[#1]

Please could  someone assist me in putting a sort on the following data:

CatNo	=Sum (total_inv_line_value*invnewproduct)	ShortDescription
A	63778.16	Blue
B	1005269.22	Green
C	31500	Yellow
D	47914	Red

I need to sort the column which is based on the expression t descending Value.

ALSO Id be very happy if someone could tell me how to show the values (once in descending order) as:

1005269 M

63778 K

47914 K

31500 M

Need to round and have the correct format symbol (M or T)

Thank you !!

[sunny_talwar]

Not a problem Emma,

I am glad I was able to help.

Best,

Sunny