Forum Discussion
jwjwjwjwjw
Advocate II
Advocate IIMatrix Column Sort Order
My apologies if the solution for this is already out there, I don't think it is but I figured it wouldn't hurt to check. I am using the matrix visual to compare year by year profitability of a ra...
Here is an example of Price/lb on some Fruit and veggies in two diff Cities.
In a Matrix, with PBI, how to you sort such a way that Denver prices display before Dallas prices, Column sort based on the value of the label (asc or desc)?
I'd assume it's doable, just as yet not sure how.
Dallas Denver
| Apple | $ 2.00 | $ 2.15 |
| Banana | $ 0.50 | $ 0.55 |
| Carrot | $ 1.25 | $ 1.30 |
| Celery | $ 1.75 | $ 1.80 |
| Mango | $ 2.50 | $ 2.55 |
| Spinach | $ 1.50 | $ 1.55 |
Anyone any direction? Thanks in advance.
SR