Producing historical data reports
...
Run the following Query to Excel for the past three like terms: UW_RS_SCH_HIST_ENRL_SB – All three terms in one query (doesn’t matter the order)
...
Once the Pivot table is set up you need to stop subtotaling rows – check it off for Career, Acad Group, Acad Org, Subject and Catalog - right click on the cell and unselect subtotal, right click Total Sum of Enrollment Total and Total Sum of Cap Enrl and select remove grand total. Also remove Grand total of last row of the data (bottom of spreadsheet)
Freeze the top rows: delete the 2 top blank rows. Select the first row under the blue area, select view tab, select freeze panes, and then click freeze panes
Right click on any cell and select pivot table options, go to display, click Classic PivotTable layout. After doing this go back and unselect it (makes the view easier to read)
Select whole pivot table again and click the line between the A&B column to resize
Save to R:\Scheduling\Data Analysis\Historical Data & CEM reports\Historical Reportsthe Teams channel “Scheduling and Exams” under Data Analysis. Send to scheduling staff to check for mistakes.
...