Well here goes... I have a list of products which each have a distinct ProductID. I have set up several Sets (A Product List, B Product List and C Product List). Is it possible to set up a Calc Field to allow switching from one Set to another? I can do it manually by dragging the Sets on and off the Filter Shelf. It would be cool to set up a Calc field and its Quick Filter to switch from list to list.
Are you using 8.0? If so, then you can create a string parameter and your sets in a calculated field and have them switch. (Note if you're using Excel, you'll want to take an extract, as sets don't work in calculated fields with Jet data sources)