I am trying to get the filter information from the first column of the pivot table in the "Sheet1" of attached file.
However, I can't find any filter either in pivottable.PivotFilters or pivotField.GetPivotFilters(). Is there a way I could get the filter info from the attached file?
In addition, if I click the sort descending in the filter, is there a way to get this information as well?
Thanks and regards