get name of data field that is used in value filter of my pivot field

**esbencito** · 12-11-2019, 06:06 AM

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?

Please Login or Register  to view this content.

doesn't work

Please Login or Register  to view this content.

works, but only if I know the index of the filter within the pivot table....

**rorya** · 12-11-2019, 06:09 AM

You could use:

Please Login or Register  to view this content.

**esbencito** · 12-11-2019, 06:16 AM

Works! But what if my pivot field has a label AND a value filter. Is there no syntax for just value filters?

**rorya** · 12-11-2019, 06:27 AM

I don't know offhand - you can't do that in 2010 which is all I have in front of me.

**esbencito** · 12-11-2019, 06:30 AM

Ok. Is there a way to check if the pivot field HAS a filter first? Otherwise it will throw an error if I use

Please Login or Register  to view this content.

and it has none...

**rorya** · 12-11-2019, 06:33 AM

Check the PivotFilters.Count is greater than 0

**esbencito** · 12-11-2019, 06:39 AM

ups, sorry! I wrongly remembered that this only works for the whole pivot table not a specific pivot field! Thanks!!

Re: get name of data field that is used in value filter of my pivot field