Skip to main content

System Status: 

QueryLink and Excel PivotTables

With QueryLink you can download data directly into an Excel PivotTable.

Features

  • Creating: QueryLink automatically defines and creates a PivotTable when you choose the data you want.
  • Downloading: To download the data, select "Excel 2000/XP PivotTable" from the drop down list at the bottom of Query pages.
Downloading dropdown screenshot


Sample PivotTable


Sample PivotTable screenshot

Need more information? Learn about using Excel PivotTables with Microsoft's tutorial or attend the Advanced Microsoft Excel class offered through UC Learning Center.

To report an incident or suggest an enhancement, submit a service request to ACT-DBWAREHOUSE@ucsd.edu.
For any general Data Warehouse related questions or comments, e-mail ITS-DATAWAREHOUSE@ad-ucsd.edu.