This is not straight forward. You will have to union your data so as to get the desired result.
Please check the attached workbook.
Let me know if this helps.
custom groups.twbx 17.9 KB
The easiest method would be to create a parameter and then create a calculated field:
Set it from your and add on the East Region Only etc to the parameter list.
Then create a boolean calculation:
if [Regions] = 'East Region Only'
elseif [Regions] = 'West Region Only'
then CONTAINS([Region], 'West')
elseif [Regions] = 'All regions except West'
then not CONTAINS([Region], 'West')
elseif [Regions] = 'All regions except East'
then not CONTAINS([Region], 'East')
else [Regions] = [Region]
So now bring that calculated field into to the filters and set it to true. Then the parameter should act as the filter:
Please see the attached workbook so that you see what's been done.
Region Parameter_v10.2.twbx 10.0 KB
This requirement cant be achieved using grouping.You need to create a set for achieving the solution.As same value cant be present in two diffferent groups like you want east to be present in east as well except east as well as except west which is only possible and easy by the help of set.create four sets for east,west,except east,except west and in east set select manually every value that corresponds to that set just by single right click on the value which you want to take in a particular set ...then by dragging these sets on canvas you can see in and out members of a particular set,like here i have a name coloumn and a region coloumn.
So when i drag name,region and the four created set to rows shelf..i get each guy of each region visible with either in our out of that set..Please look at attached workbook....
set.twbx 13.0 KB