Use the PivotPageFieldCollection.Add method of the PivotTable.PageFields collection. Use the PivotFieldReferenceCollection.Add method of the PivotTable.ColumnFields collection. Use the PivotFieldReferenceCollection.Add method of the PivotTable.RowFields collection. To add a field to the PivotTable report, access the required field by its name in the collection (by default, field names originate from the column labels in the source range) and move it to one of four PivotTable areas, listed in the table below. All pivot fields are stored in the PivotFieldCollection collection returned by the PivotTable.Fields property. To fill the created pivot table with data, add the necessary fields to it. You can use a cell range as the data source for your PivotTable report, or base it on the data cache of the existing pivot table (for details, see PivotCache). ![]() ![]() To create a new pivot table, use the PivotTableCollection.Add method of the Worksheet.PivotTables collection accessed for a worksheet where the report should be located. The following examples demonstrate how to use the Pivot Tables to create a pivot table, which summarizes data in a cell range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |