Mixture of 'And' and 'Or' in set analysis

[#1]

Hi,

I need to use set analysis to limit a table of orders based on certain conditions, which are:

- The order must be have an OrderType of 'Booked'

- The order must either have a Class of 1 or a Category of 1

i.e. OrderType = 'Booked' AND (Class = 1 OR Category = 1)

I've been trying to write some set analysis using intersection but i can't get it right and always gives me errors. Can someone help?

Thanks

[anbu1984]

Sum({<OrderType = {'Booked'},Class = {1}>+<OrderType = {'Booked'},Category = {1}>} Sales)