Change Order of Sheets in Report

Art Schneiderheinze

I have two sheets that show data from two different fiscal years:

• [FY 2019] Course Development Tracker
• [FY 2020] Course Development Tracker

I added both of these to the Report Builder, but I want the data in [FY 2020] Course Development Tracker to appear above the data in [FY 2019] Course Development Tracker.

I thought they were just added alphabetically, so i renamed them to this, thinking it would alphabetize FY 2020 on top, and display that data in the report first. 

• [b-FY 2019] Course Development Tracker
• [a-FY 2020] Course Development Tracker

It does not. It still puts data from FY 2019 on top. 

I even tried renaming them numerically, but still get the same results (see attached screenshot):

• [2-FY 2019] Course Development Tracker
• [1-FY 2020] Course Development Tracker

Any thoughts to name the Sheets or add the sheets to the Report Builder to have the current FY 2020 data appear on top?

Andrée Starå

Hi,

How are you sorting the information in the report?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Art Schneiderheinze

I'm not sorting it. I have the same columns in both sheets, and I just choose the columns I want to display (and the order to display them). 

 

Art Schneiderheinze

Figured it out indirectly from your help. I added Sheet Name (as a column), hid it, then sorted by sheet. That worked.

Andrée Starå

Excellent!

That was my thought as well!

Happy to help!

Best,

Andrée