Dear sir/madam,
For my company I am trying with your trial version of Aspose Cells to set the filter on a pagefield within a pivot table. I discover that this is not possible. I would like to set a filter and by that way see how the graph changes that is based on the pivot table.
I am curious if you have a solution for this.
Best regards,
Nico Horsmans
I am working with Excel 2007 and I am trying to do so in C# .NET.
Regards,
Nico Horsmans
Hi,
Well, I think you may try to use:
PivotField.HideItem(int index, bool isHidden)/PivotField.HideItem(string itemValue, bool isHidden)
method several times (accordingly) to hide all the items except for your desired item
for which you need to select in the drop down.
Thank you