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)
...
Select only the data, then go the Insert tab, select pivot table, ensure “yes to new worksheet” is selected, then just click ok
In the Pivot Tale Table Fields, as seen below click and drag the options to the boxes except with the exception noted in step C:
Note that you do not drag over “Values”, it will appear once the Sum of Enrollment and Sum of Cap Total are dragged down
...