I have a chart with a single dimension and 16 expressions. There are 8 sales expressions (one for each of our locations) and 8 profit expressions (again, one for each location). The end user selects a location and an option (sales and/or profit), and the (conditional) expressions show up on the chart - great! However, in QV 8.5, the legend is sorted by order of the expressions. I can change the legend LABEL to not appear based on GetFieldSelections function, (but the symbol still appears), yet I cannot sort the legend values. Any direction would be greatly appreciated.
Understand that you currently use expressions like SUM(IF(Location = 'XXX', Sales)). Think it makes more sense to use the location as a dimension, for which you may define sorting-options as per an expression and to have only the expression SUM(Sales).
