Check if any table field is filtered by user

[hugmarcel]

Hi

I have a table A with fields field1, field2, field3, ..., field20. There is a listbox for every field.

How can I check in a pivot formula, if any of the table A fields is filtered in the listbox by the user?

Thx - Marcel

[SunilChauhan]

take a Current selection box

it will show you all selection by user.

hope this helps

[hugmarcel]

and how to check / evaluate the content of the Current selection box in the pivot formula?

[#4]

You can try the getfieldselections() function. It will allow you output the text of the currently active selections for a particular field. You can also specify the separator to go between the text in the case of multiple active selections in a single field.

Check the manual for details on getfieldselections(). Hope this helps!