# GrapeCity.Documents.Excel.IPivotTable.ClearAllFilters

## Content

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



<h1 id="GrapeCity_Documents_Excel_IPivotTable_ClearAllFilters_" data-uid="GrapeCity.Documents.Excel.IPivotTable.ClearAllFilters*">ClearAllFilters Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_IPivotTable_ClearAllFilters_" data-uid="GrapeCity.Documents.Excel.IPivotTable.ClearAllFilters*"></a>
<h4 id="GrapeCity_Documents_Excel_IPivotTable_ClearAllFilters" data-uid="GrapeCity.Documents.Excel.IPivotTable.ClearAllFilters">ClearAllFilters()</h4>
<div class="markdown level1 summary"><p>Deletes all filters currently applied to the pivot table.</p>
<p>
This method removes filters in the pivot table's filter collection, clears
manual filtering, and resets all pivot fields in the Report Filter area to
their default item.
</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">void ClearAllFilters()</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Sub ClearAllFilters()</code></pre>
</div>
<h5 id="GrapeCity_Documents_Excel_IPivotTable_ClearAllFilters_examples">Examples</h5>
<pre><code class="lang-csharp">object[,] sourceData = {
    {"Product", "Country", "Amount"},
    {"Apple", "Canada", 120},
    {"Apple", "France", 150},
    {"Banana", "Canada", 90}
};
worksheet.Range["A1:C4"].Value = sourceData;
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:C4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["E1"], "PivotTable1");
IPivotField fieldProduct = pivotTable.PivotFields["Product"];
fieldProduct.Orientation = PivotFieldOrientation.RowField;
IPivotField fieldAmount = pivotTable.PivotFields["Amount"];
fieldAmount.Orientation = PivotFieldOrientation.DataField;
fieldProduct.PivotFilters.Add(PivotFilterType.CaptionContains, "pp");
pivotTable.ClearAllFilters();</code></pre>

</div>