Forum Discussion
Counting Invoices when there are duplicates
I have a data set that has a listing of multiple invoices with the invoice number repeated because the data also had the product that was sold. I need to generate a report, for each month of the yea...
Thank you for your attempt. This is not what I was looking for.
For instance. Customer D for January, the pivot table shows 7. The answer really is 2. There were only two orders in January. On the 2 orders, there were 7 items.
Any other thoughts?
In the attached version of the workbook, I added the data source to the data model, then used Distinct Count as summary function for the Document No. field.
Does that do what you want?
