I hope I understand your question correctly, but it sounds like you want to be able to identify and filter out all orders w/ >1 customer. Is that correct?
If so, then the steps I would take are:
1. Create an extract so you can use the CNTD (aka Count Distinct) function
2. Right click on Customer and drag it to your view, selecting CNTD as your calculation.
3. Select the CNTD(Customer) pill, right-click and select Show Quick Filter.
4. Change your filter to At Most 1.
See Sheet 2 in the attached. Hope this is what you were looking for.
question.twbx.zip 407.0 KB
hey, seems the way works in the reverse way. I would like select >1 option actually.
however this way can't see what customer are included in this order. My sheet was the result I want to see, just my way is manual work, I want a programmed one
by your inspiration, I reached correct answer, take a look at my revised example workbook, sheet "programmed", that's the result with easier condition setting on OrderID
I wasn't able to see your solution as you didn't attach your workbook. :-)
But I added a new tab that uses a simple table calculation to arrive at your desired result, namely a list of all orders w/ greater than 1 customer along with the names of the customers per order. I wonder how close this is to the solution you came up with.
question.twbx.zip 426.7 KB
thanks Mike, my revised result was attached in my first post, you can download it to take a look.
thanks for your help