Aggr Function with multiple criterias

[Fabien]

Hi all,

I'm hoping you can help me with this tricky one.

I would like to be able to set a filter pane or button with the following criterias in one go:

I would like to filter the selection to  all products within brand 'AAA' and also product '222' and '333' within brand BBB.

Brand	Product
AAA	111
AAA	222
BBB	111
BBB	333
BBB	222
AAA	333

Is it possible to do so?

[rwunderlich]

{<Brand={'AAA'}> + <Brand={'BBB'}, Product={222,333}>}

[Fabien]

Thanks for your response.

Should that go into an Aggr function?

It doesn't seem to work on its own in a filter pane

[rwunderlich]

Yes, an Aggr() if you wanted to make a filter.  You said filter or button so i assumed you were just looking for the set. Where you use it depends.  For a Filter:

Aggr(Only({<Brand={'AAA'}> + <Brand={'BBB'}, Product={222,333}>} Product), Product)

-Rob

[Fabien]

Thanks Rob but it didn't work.