|
|
|
|
|
|
|
|
|
PT - Pivot Tables Using pivot tables, one can create some reports that may not be possible in Premier or may be easier for people to create. In a matter of seconds, you can take thousands or rows of data and summarize the information. Advantages include several views without having to print several reports and that the file can be viewed by non-admins. The main disadvantage is unless you're using ODBC, the data is static, or based on data as new as the last extract. But in some cases, such as viewing grades breakdowns for Q1, static is fine. Following are a couple examples of using Excel to create a pivot table. The information for the table must first be extracted from the database. Each page lists the data used as well as the placement on the pivot table. |
