How to sort custom measures by their values?

[lijiang]

I’m working on a dataset that has data as below.

Industry	No. Of Deals
[A, B]	5
[A, C]	10
	2
[C, D]	9

For some reason, derived table is not an option and I have to do the calculation inside the report using custom measures. I created four custom measures for A, B, C, D respectively to calculate the No. of Deals for each of them. And I’ve got results like this:

A	B	C	D
15	7	19	9

The question is, how can I sort them in the column chart from large to small?

Thanks!