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;


    

1C:Enterprise Developer's Community