SSRS Pie Chart Sorting

Question

This may be a simple question for someone. Can someone show me how to sort or order the slices of pie? I can sort a bar chart no problem, but there must be something a little different with Pie Charts.

I would like the amounts in order and not scattered around. What am I doing wrong?

Here's my expression to group.

Here's my expression to sort.

and here's where I add the sort options

My Pie chart.

Answer 1

So, I continued to work on this and I found that if I sort by the actual dataset field called Total Acct MV instead of the calculated 'Total MV Group' or the calculated field called 'Total MV Sorted' ...then it works fine.