Sort in Report Builder

[frankieblue22]

Report Builder won't sort correctly.  I have a simple build with columns of Day, Department, and Revenue. I'd like it to sort the top 10 departments each day.  Adjusting the up/down arrow on the metric doesn't work.  

This is just an example of the issue. I'm currently pulling a bigger data set and formulating off of it to get what I need.

The question remains for data pulls where formulating isn't practical.  Why can't Report Builder easily sort?

[Nick_Walter]

Because of issues like this I have seem people do one of 2 things commonly in excel with report builder. 

1) Flow the report directly into an excel table

This allows you to more easily sort or filter the report after it has ran but in this case would still be difficult when it is aggregated by day.

2) Pull the data into one tab, then set up a pivot table either next to it or in a new tab. This allows for more advanced manipulation without needing to format the original data pull.