sorting legend based on two criteria
I have a simple dataset that contains each supplier's sale in each year. I made a bar chart with years in the x axis and suppliers' sale on the y axis and used supplier company as legend. I want to sort the legend (suppliers) in each bar (year) based on the total sales of that supplier in that specific year. I can sort them by all-time total sales of suppliers, but I dont know how to do this sorting in each year.
Sort matrix by measure..but 2nd level rows ignore sort
Hey everyone. I have a simple matrix that sorts by volume. I also have a time calculation group for Current and PY and the ordinal is set to the correct sort order. However...sorting the Matrix overrides the sort order of the calculation group. Is there a way to sort the matrix by the volume measure...but ignore the sort for the calculation group?
