I have a need to do a Top 10 Report of Service Groups over a period of 6 months and to sort these. However, when I sort these and put them on a stacked bar the order is the same, whether or not it is in top 9th spot or top 8th spot. Is there a fix for this?
Looking at example month_end 2017-12 vs 2018-01, 7th and 8th spot rotating between LASD and ESB.
Main concern, is that some months the service groups may be completely different..