# C1.PivotEngine.Subtotal

## Content

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




  <h1 id="C1_PivotEngine_Subtotal" data-uid="C1.PivotEngine.Subtotal" class="text-break">Subtotal Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies the type of subtotal (aggregate) statistic to calculate.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.PivotEngine.html">C1.PivotEngine</a></h6>
  <h6><strong>Assembly</strong>: C1.PivotEngine.dll</h6>
  <h5 id="C1_PivotEngine_Subtotal_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum Subtotal</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum Subtotal</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="C1_PivotEngine_Subtotal_Average">Average</td>
        <td><p>Gets the average of a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_Count">Count</td>
        <td><p>Gets the number of values in a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_CountDistinct">CountDistinct</td>
        <td><p>Gets the distinct count of a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_Expression">Expression</td>
        <td><p>Gets the value of the evaluated expression</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_First">First</td>
        <td><p>Gets the first value in a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_Last">Last</td>
        <td><p>Gets the last value in a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_Max">Max</td>
        <td><p>Gets the maximum value in a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_Min">Min</td>
        <td><p>Gets the minimum value in a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_Std">Std</td>
        <td><p>Gets the sample standard deviation of a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_StdP">StdP</td>
        <td><p>Gets the population standard deviation of a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_Sum">Sum</td>
        <td><p>Gets the sum of a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_Var">Var</td>
        <td><p>Gets the sample variance of a group.</p>
</td>
      </tr>
      <tr>
        <td id="C1_PivotEngine_Subtotal_VarP">VarP</td>
        <td><p>Gets the population variance of a group.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>