# GrapeCity.Spreadsheet.PivotTables.IPivotItem

## Content

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



  <h1 id="GrapeCity_Spreadsheet_PivotTables_IPivotItem" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem" class="text-break">IPivotItem Interface
</h1>
  <div class="markdown level0 summary"><p>Represents an item in a <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTable.html">IPivotTable</a> field.</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_IPivotItem_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IPivotItem</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IPivotItem</code></pre>
  </div>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_Caption" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Caption">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Caption.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_Caption">Caption</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a string value that represents the label text for the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.html">IPivotItem</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_Field" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Field">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Field.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_Field">Field</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the parent field of the current pivot item.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_Formula" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Formula">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Formula.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_Formula">Formula</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value that represents the object's formula in A1-style notation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_Index" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Index">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Index.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_Index">Index</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an integer value that represents the index number of the pivot item within the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItems.html">IPivotItems</a> collection.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_IsCalculated" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.IsCalculated">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.IsCalculated.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_IsCalculated">IsCalculated</a>
        </td>
        <td class="markdown level1 summary"><p><code>True</code> if the PivotTable item is a calculated item, <code>False</code> for otherwise.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_LabelRange" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.LabelRange">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.LabelRange.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_LabelRange">LabelRange</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object that represents all the cells in the PivotTable report that contain the item.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_ShowDetail" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.ShowDetail">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.ShowDetail.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_ShowDetail">ShowDetail</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the outline is expanded for the specified range (so that the detail of the column or row is visible).
The specified range must be a single summary column or row in an outline.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_SourceName" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.SourceName">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.SourceName.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_SourceName">SourceName</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a string value that represents the specified object's name as it appears in the original source data for the specified <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotTable.html">IPivotTable</a> report.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_Visible" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Visible">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Visible.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_Visible">Visible</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a Boolean value that determines whether the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.html">IPivotItem</a> is visible.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_Delete" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Delete">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.Delete.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_Delete">Delete()</a>
        </td>
        <td class="markdown level1 summary"><p>Deletes the object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_PivotTables_IPivotItem_DrillTo_System_String_" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotItem.DrillTo(System.String)">
          <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.DrillTo.html#GrapeCity_Spreadsheet_PivotTables_IPivotItem_DrillTo_System_String_">DrillTo(string)</a>
        </td>
        <td class="markdown level1 summary"><p>This method supports drilling to a specified <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotField.html">IPivotField</a> from a <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotItem.html">IPivotItem</a>.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>