So overall the straight table values appears as 5.0 Million, 4.3 million, 3.0 thousand and so on.
Now, the problem is with sorting. I am able to get values in right sort order if expression 2 is disabled. but If I include expression 2, the sort order is getting disturbed. is there any way I can exclude expression 2 from sorting but should be shown in chart
P.S: I need to have two expressions mandatory because the client need a different font size for both. Expression1 for revenue with font size 10 and expression2 with font size 8.
Have you tried it without sort-expression. In a straight-table you could sort by a double-click on the column-header from each column. Another possibility is to use only one expression-column and add for thousands/millions simply a "k" or "m" then to show this in full-length is no added value.