# GrapeCity.Spreadsheet.PivotTables.ConsolidationFunction

## Content

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




  <h1 id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction" data-uid="GrapeCity.Spreadsheet.PivotTables.ConsolidationFunction" class="text-break">ConsolidationFunction Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies the subtotal function.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.html">GrapeCity.Spreadsheet.PivotTables</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">[Flags]
public enum ConsolidationFunction</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">&lt;Flags&gt;
Public Enum ConsolidationFunction</code></pre>
  </div>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    <thead>
    </thead></thead><tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_Automatic">Automatic</td>
        <td><p>Automatic.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_Average">Average</td>
        <td><p>Average.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_Count">Count</td>
        <td><p>Count.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_CountNumbers">CountNumbers</td>
        <td><p>Count numerical values only.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_Max">Max</td>
        <td><p>Maximum.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_Min">Min</td>
        <td><p>Minimum.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_None">None</td>
        <td><p>No subtotal function specified.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_Product">Product</td>
        <td><p>Multiply.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_StdDev">StdDev</td>
        <td><p>Standard deviation, based on a sample.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_StdDevP">StdDevP</td>
        <td><p>Standard deviation, based on the whole population.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_Sum">Sum</td>
        <td><p>Sum.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_Var">Var</td>
        <td><p>Variation, based on a sample.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_ConsolidationFunction_VarP">VarP</td>
        <td><p>Variation, based on the whole population.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>