# GrapeCity.Spreadsheet.PivotTables

## Content

<div class="doc-site-dotnet-api-container">

  <h1 id="GrapeCity_Spreadsheet_PivotTables" data-uid="GrapeCity.Spreadsheet.PivotTables" class="text-break">GrapeCity.Spreadsheet.PivotTables Namespace
</h1>
  <div class="markdown level0 summary"></div>
  <div class="markdown level0 conceptual"></div>
  <div class="markdown level0 remarks"></div>
    <h3 id="interfaces">
Interfaces
</h3>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.ICalculatedFields.html">ICalculatedFields</a></h4>
      <section><p>Represents a collection of all the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotField.html">IPivotField</a> objects in a <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTable.html">IPivotTable</a> that are calculated fields.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.ICalculatedItems.html">ICalculatedItems</a></h4>
      <section><p>Represents a collection of all the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.html">IPivotItem</a> objects that represents all the calculated items in a <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTable.html">IPivotTable</a> report.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotCache.html">IPivotCache</a></h4>
      <section><p>Represents the memory cache for a PivotTable report.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotCaches.html">IPivotCaches</a></h4>
      <section><p>Represents the collection of memory caches from the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTable.html">IPivotTable</a> reports in a workbook.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotField.html">IPivotField</a></h4>
      <section><p>Represents a field in a pivot table report.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotFields.html">IPivotFields</a></h4>
      <section><p>A collection of all the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotField.html">IPivotField</a> objects in a pivot table report.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotFilter.html">IPivotFilter</a></h4>
      <section><p>Represents a filter applied to a PivotTable field.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotFilters.html">IPivotFilters</a></h4>
      <section><p>Represents a collection of filters applied to a PivotTable.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotFormula.html">IPivotFormula</a></h4>
      <section><p>Represents a formula used to calculate results in a PivotTable report.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotFormulas.html">IPivotFormulas</a></h4>
      <section><p>Represents a collection of formulas for a PivotTable report.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.html">IPivotItem</a></h4>
      <section><p>Represents an item in a <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTable.html">IPivotTable</a> field.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItems.html">IPivotItems</a></h4>
      <section><p>Represents a collection of all the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.html">IPivotItem</a> objects in a <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTable.html">IPivotTable</a>.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTable.html">IPivotTable</a></h4>
      <section><p>Represents a PivotTable report on a worksheet.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTableCellType.html">IPivotTableCellType</a></h4>
      <section><p>Represents the cell type of pivot table cell.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTables.html">IPivotTables</a></h4>
      <section><p>Represents a collection of all the PivotTable objects in the specified object.</p>
</section>
    <h3 id="enums">
Enums
</h3>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.ConsolidationFunction.html">ConsolidationFunction</a></h4>
      <section><p>Specifies the subtotal function.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.FieldSortType.html">FieldSortType</a></h4>
      <section><p>Represents the sort type of a pivot field.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.LayoutFormType.html">LayoutFormType</a></h4>
      <section><p>Specifies the way the specified PivotTable items appear—in table format or in outline format.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.LayoutRowType.html">LayoutRowType</a></h4>
      <section><p>Specifies the type of layout row.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.PivotFieldCalculation.html">PivotFieldCalculation</a></h4>
      <section><p>Represents the type of calculation performed by a data PivotField when a custom calculation is used.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.PivotFieldDataType.html">PivotFieldDataType</a></h4>
      <section><p>Specifies the type of data in the PivotTable field.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.PivotFieldOrientation.html">PivotFieldOrientation</a></h4>
      <section><p>Specifies the location of the field in a PivotTable report.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.PivotFilterType.html">PivotFilterType</a></h4>
      <section><p>Represents the type of filter applied to a <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotField.html">IPivotField</a></p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.PivotGroupPeriods.html">PivotGroupPeriods</a></h4>
      <section><p>Defines grouping periods for date field on a pivot table.</p>
</section>
      <h4><a class="xref" href="GrapeCity.Spreadsheet.PivotTables.SubtotalLocationType.html">SubtotalLocationType</a></h4>
      <section><p>Specifies where the subtotal will be displayed on the worksheet.</p>
</section>


</div>