# GrapeCity.Documents.Excel.IPivotItem

## Content

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



  <h1 id="GrapeCity_Documents_Excel_IPivotItem" data-uid="GrapeCity.Documents.Excel.IPivotItem" class="text-break">IPivotItem Interface
</h1>
  <div class="markdown level0 summary"><p>Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems
collection. The PivotItems collection contains all the items in a PivotField.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.html">GrapeCity.Documents.Excel</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_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_Documents_Excel_IPivotItem_Formula" data-uid="GrapeCity.Documents.Excel.IPivotItem.Formula">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.Formula.html#GrapeCity_Documents_Excel_IPivotItem_Formula">Formula</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the formula of calculated item.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotItem_Name" data-uid="GrapeCity.Documents.Excel.IPivotItem.Name">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.Name.html#GrapeCity_Documents_Excel_IPivotItem_Name">Name</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the name of the object (read or write).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotItem_Position" data-uid="GrapeCity.Documents.Excel.IPivotItem.Position">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.Position.html#GrapeCity_Documents_Excel_IPivotItem_Position">Position</a>
        </td>
        <td class="markdown level1 summary"><p>Position of the item in its field if the item is currently showing. Read/write Integer.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotItem_ShowDetail" data-uid="GrapeCity.Documents.Excel.IPivotItem.ShowDetail">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.ShowDetail.html#GrapeCity_Documents_Excel_IPivotItem_ShowDetail">ShowDetail</a>
        </td>
        <td class="markdown level1 summary"><p>True if the outline is expanded for the specified range (so that the detail of the column or row is visible). Read/write Object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotItem_SourceName" data-uid="GrapeCity.Documents.Excel.IPivotItem.SourceName">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.SourceName.html#GrapeCity_Documents_Excel_IPivotItem_SourceName">SourceName</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the specified object’s name as it appears in the original source data for the specified PivotTable report. This might be different from the
current item name if the user renamed the item after creating the PivotTable report (read-only).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotItem_Visible" data-uid="GrapeCity.Documents.Excel.IPivotItem.Visible">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.Visible.html#GrapeCity_Documents_Excel_IPivotItem_Visible">Visible</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the object is visible (read or write).</p>
</td>
      </tr>
    </tbody>
  </table>

</div>