One option may be to create a calculated field to pull out the 'Fruit' member of the dimension, similar to the following.
if [Dimension1]="Fruit" then "Fruit" else "Sub-items" end
Then, place this field on the filter shelf and select Show Quick Filter. On the quick filter, Customize so that it is a Single Select Filter and customize it so that the All option is not available. Then, show the quick filter for Dimension1. In the quick filter menu, select 'Show Only Relevant Values.' Customize it so that it does not show the 'All' option and change it to a Multiple Values quick filter.
Hope this helps!
Hmmm, I'm not sure that works Tracy. Could you post a workbook using the Superstore [Category] field and say 'Bookcase' as the item that's being pulled out? Thanks, I'll be interested to see what I'm doing wrong.
My sincere apologies. I had typed 'Bookcase' instead of 'Bookcases', so of course I was only getting a single filter choice. Thanks,
Cool trick, learned something new today!
It's very cool.Sorry for response later. I worked in other side of world.
This knowledge you share is very useful,we are going to implement it in our report after performance test.And that is second time you help me.Thanks a lot.
My original thinking is to constrain all selection control in one filter.just like in some web page.when you select one item.other item become dark and can't be chosen any more. In that way,you can keep fewer element on the web page.So it will become more clean and simple. But I think tableau didn't open that kind of interface to users or made that into a built-in function.
The option you give is very close to things we want.thanks again.