PivotField Methods
Represents a field in a PivotTable report.| Name | Description |
|---|---|
| GroupItems(PivotFieldGroupByType) | Performs grouping of the specified type in the current field. |
| GroupItems(PivotGroupingValue, PivotGroupingValue, Double, PivotFieldGroupByType) | Performs field grouping using the specified grouping properties. |
| GroupItems(IEnumerable<Int32>) | Groups the specified items in the field. |
| GroupItems(DateTime, DateTime, Int32, PivotFieldGroupByType) | Performs grouping by dates in the specified interval. |
| GroupItems(Double, Double, Double) | Performs numeric grouping in the current field. |
| SetSubtotal(PivotSubtotalFunctions) | Specifies the function(s) to calculate subtotals for the PivotTable field. |
| SetSubtotalAutomatic() | Displays automatic subtotals for the PivotTable field. |
| ShowAllItems() | Displays all items in the PivotTable field. |
| ShowSingleItem(Int32) | Displays the specified item in the PivotTable field. |
| SortItems(PivotFieldSortType, Int32, PivotItemReference[]) | Sorts items in the current pivot field based on values in the specified data field. |
| SortItems(PivotFieldSortType, Int32, IEnumerable<PivotItemReference>) | Sorts items in the current pivot field based on values in the specified data field. |
| UngroupItems() | Removes grouping for the current field. |
| UngroupItems(IEnumerable<Int32>) | Removes the specified items from grouping. |
See Also