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. I've attached a pivot solution.
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?
- Now that I am going into my second year with this data, I figured I would need to use Power Query, so this is going to work fantastic for me. Thank you!
- Not sure I undestand why you would need to use Power Query...
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?
