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)
Hope this helps!