Pivot table
Pivot tables provide a universal mechanism for display and interactive analysis of multi-dimensional data obtained as query results in a spreadsheet document.Example:
Result = Query.Execute(); PivotTable = Controls.SprDocField.EmbeddedTables.PivotTable; PivotTable.DataSource = Result; |