I would like to understand, how can we enable the sorting in trelli charts. In my case, I am showing Top 10 Vendors ie vendors who are selling more Materials for 3 consecutive Years. and for each year, I would like sort the value in descending order. how do I do that, so far the dimension is single it works fine, but when it exceeds one, the sorting does not work as it should be. I tried to do sorting based on Expression, but that does not work in case of Trellis. Any timely help would be greatly appreciated.
Attached the qvw and please refer (sheet 7) Top 10 vendors Trellis
Yes, I am also getting the same result. I was wondering, whether the value could be actually descending, but since it tries to order the same set of materials for each year. I wanted for each year arrange it in descending year. Is that doable ?