Combine Set Expressions

[leobrand]

I want to create a set expression that includes customers that purchased “Running Shoe A” while excluding customers that purchased this shoe from the vendor “Sporting Goods Store”.  Can you help me combine the set expressions below into one in order to do this?

Sum({1<Customer=(P({1<ProductName={Running Shoe A}>}))>}LineSalesAmount)

Sum({1<Customer=(E({1<Vendor={Sporting Goods Store}>}))>}LineSalesAmount)

[sunny_talwar]

May be this

Sum({1<Customer=P({1<ProductName={Running Shoe A}>})*E({1<Vendor={Sporting Goods Store}>})>}LineSalesAmount)

[sunny_talwar]

Or one of these

Sum({1<Customer=P({1<ProductName = {'Running Shoe A'}>})*E({1<Vendor={'Sporting Goods Store'}, ProductName = {'Running Shoe A'}>}), ProductName = {'Running Shoe A'}>}LineSalesAmount)

Sum({1<Customer=P({1<ProductName = {'Running Shoe A'}>})*E({1<Vendor={'Sporting Goods Store'}, ProductName = {'Running Shoe A'}>})>}LineSalesAmount)