Sort in Report Builder | Community
Skip to main content
F
frankieblue22
September 12, 2024
Question

Sort in Report Builder

  • September 12, 2024
  • 1 reply
  • 585 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Nick_Walter
Community Advisor and Adobe Champion
Nick_WalterCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 12, 2024

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.

Terms & ConditionsAccessibility statement

Loading footer...