Hi all,

I use a value filter for my pivot field "MATERIAL". How can I get the name of the data field that is used in that filter?

.PivotFields("MATERIAL").PivotFilters.DataField
doesn't work

pt.ActiveFilters(2).DataField
works, but only if I know the index of the filter within the pivot table....