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 !!

[Anonymous]

Emma,

Have you tried to change the sorting options you have in the Sort tab in object properties?

Please attach a sample file for deeper understand of your requirement.

Marc.

[sunny_talwar]

How do you determine if we need to add a M or K?

Best,
Sunny

[#4]

7 spaces to the left of the decimal

[tcullinane]

to sort on the value use the expression option in sort tab and put in the expression you want to sort on. ie the calculation  =sum(total...)

o vary between M and k i'm assuming you mean Million of thousand, probably best/easiest to pick the appropriate one and divide by 1000 (or 1000000) and use the number format tab to include k (or M) in the format. note its a small k for thousand not capital.

[sunny_talwar]

So the one in the red isn't right, right?

1005269 M

63778 K

47914 K

31500 M (Should be K here?)

Just making sure I understand this well enough.

Best,

Sunny

[#7]

Yes, apologies Sunny

[#8]

hello please find attached QVW for the sorting order...

[sunny_talwar · Accepted solution]

No problem. Please look at the attached qvw and see if this is helpful.

Best,

Sunny

[#10]

This has worked perfectly Sunny.

I really appreciate your help with this one!

Many thanks