This project has moved. For the latest updates, please go here.

Filters in Pivot Table

Jul 20, 2016 at 8:08 PM
Hi guys, I recently check this project and it's so good. Well, i have a question: How I can add filters to row or columns fields in Pivot Tables, i saw a property in RowField that names "IncludeNewItemsInFilter", is this something related with filters? Thanks in advance.
Aug 2, 2016 at 5:48 PM
I dont know, how you cook it^

check my sample at :
external link
Jan 6 at 4:26 AM
Assuming you have a List<string> of column names that you want to create filters for and a variable for the pivot table (e.g., pivotTable in the text below), you just add a field to the PageFields collection for each filter that you want to create. The sort is optional; if your data is already sorted you can leave it out.
foreach (string filter in filterColumns)
{
    var field = pivotTable.Fields[filter];
    pivotTable.PageFields.Add(field);
    field.Sort = eSortType.Ascending;
}