Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Shouldn't this work to show all account numbers that have both '1027073" and 'C#XIO' - and is there an easier way? =count({}[Account Movex Number])>*}DISTINCT[Account Movex Number])
Try this.. if you want to get Accounts that has TWO products. AND operator.
Count({<Account=P({<Product={'1027073'}>})*P({<Product={'C#XIO'}>}),Product={'1027073','C#XIO'}>} Distinct [Account Movex Number])
Adjust Account and Product fields according to your datamodel.
=count({}[Account Movex Number])>*}DISTINCT[Account Movex Number])
Try this.. if you want to get Accounts that has TWO products. AND operator.
Count({<Account=P({<Product={'1027073'}>})*P({<Product={'C#XIO'}>}),Product={'1027073','C#XIO'}>} Distinct [Account Movex Number])
Adjust Account and Product fields according to your datamodel.
Excellent! Thank you so much Phaneendra.