Please could someone assist me in putting a sort on the following data:
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:
Need to round and have the correct format symbol (M or T)
Thank you !!
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.