Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
May be this
Sum({1<Customer=P({1<ProductName={Running Shoe A}>})*E({1<Vendor={Sporting Goods Store}>})>}LineSalesAmount)
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)