# GrapeCity.Spreadsheet.PivotTables.PivotFieldCalculation

## Content

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




  <h1 id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation" data-uid="GrapeCity.Spreadsheet.PivotTables.PivotFieldCalculation" class="text-break">PivotFieldCalculation Enum
</h1>
  <div class="markdown level0 summary"><p>Represents the type of calculation performed by a data PivotField when a custom calculation is used.</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_PivotFieldCalculation_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum PivotFieldCalculation : byte</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum PivotFieldCalculation As Byte</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_PivotFieldCalculation_DifferenceFrom">DifferenceFrom</td>
        <td><p>The difference from the value of the Base item in the Base field.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_Index">Index</td>
        <td><p>Data calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_NoCalculation">NoCalculation</td>
        <td><p>No calculation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentDifferenceFrom">PercentDifferenceFrom</td>
        <td><p>Percentage difference from the value of the Base item in the Base field.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentOf">PercentOf</td>
        <td><p>Percentage of the value of the Base item in the Base field.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentOfColumn">PercentOfColumn</td>
        <td><p>Percentage of the total for the column or series.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentOfParent">PercentOfParent</td>
        <td><p>Percentage of the total of the specified parent Base field.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentOfParentColumn">PercentOfParentColumn</td>
        <td><p>Percentage of the total of the parent column.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentOfParentRow">PercentOfParentRow</td>
        <td><p>Percentage of the total of the parent row.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentOfRow">PercentOfRow</td>
        <td><p>Percentage of the total for the row or category.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentOfTotal">PercentOfTotal</td>
        <td><p>Percentage of the grand total of all the data or data points in the report.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_PercentRunningTotal">PercentRunningTotal</td>
        <td><p>Percentage of the running total of the specified Base field.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_RankAscending">RankAscending</td>
        <td><p>Rank smallest to largest.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_RankDescending">RankDescending</td>
        <td><p>Rank largest to smallest.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_PivotFieldCalculation_RunningTotal">RunningTotal</td>
        <td><p>Data for successive items in the Base field as a running total.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>