1.3 Pivot Tables

Use data from the Gateway in Pivot Tables.

1. Import data (see Import Data)
2. Select a cell in the table
3. Insert → PivotTable
4. Select and arrange fields

• Filter large datasets first
• Refresh regularly for current numbers
• Multiple tables? Use Power Pivot

1. Right-click on data connection
2. Properties
3. Enable Refresh every X minutes