Can you provide a sample workbook or sample data, and your expected result?
1 of 1 people found this helpful
I would create a parameter that is linked to your current filter and then write a calculated field that selects the options you are looking for dependent upon the parameter selection.
That did the trick. Thanks Tim