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!