Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 4 filters and one pivot table. i want change the values in a pivot table and show the related to filter, when i select the filter.
You can use:
GetFieldSelections(FilterName)
Br,
KC
FilterName means i have to enter the four filters name Like .
GetFieldSelections(Filter1, Filter2, Filter3, filter4)
Do you want to show all the filter in a single filed ?
Then try like this:
GetFieldSelections(Filter1) &' '&GetFieldSelections(Filter2) &' '&GetFieldSelections(Filter3)
Br,
KC
When you say filter, is one filed containing many values or multiple fields itself ?