conditional filters for selecting multiple dimensions.

[coloful_architect]

Hi gurus,

I  have a group of dataset like this 

data	Attributes	Flag
a	Red	yes
b	Blue	no
c	Purple	yes
d	colorful	no
e	colorful	no
f	colorful	yes
g	White	no

if I filter out Flag yes, it returns me data with Red, Purple and Colorful.

data	Attributes	Flag
a	Red	yes
c	Purple	yes
f	colorful	yes

is there a way, at filter panel for either Attributes or Flag , to achieve a conditional filter to only have Red and Purple without colorful.

I am thinking an expression like " if Flg = Yes, only attributes =Purple and Red"

any other ways to achieve this is also welcome. 

much appreciated.

[GaryGiles]

Are you looking for something like:

aggr(Only({$<Flg={'Yes'},Attributes={'Red','Purple'}>} Attributes), Attributes)

or, to exclude 'colorful' instead of including 'Red' and 'Purple, use:

aggr(Only({$<Flg={'Yes'},Attributes-={'colorful'}>} Attributes), Attributes)

[coloful_architect]

ummm I tried this .but the panel filter of attributes turn to be only red , purple. 

By default, I want to have that attributes panel filter to have all the data ( all colors )

I guess if I have to recreate a demission  particularly for yes Flag + Purple +Red ?