I am trying to create a stacked bar chart and sort by total sales. I have a field in the legend so I can see the composition of total sales. For some reason it is not sorting the chart descending by total sales like expected. What am i missing here ?
setup: as you can see I have sales dollars descending in the sorting yet for some reason it is not producing the expected format. Redacted y axis for privacy