Seafood Dutch
New Member
- Joined
- Nov 27, 2023
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
I have a table that contains, customer name, customer number, invoice number (alpha and number combination), invoice date, invoice amount and product code for each product on an invoice (this makes there to be multiple rows for each invoice).
I want to create a dynamic report that shows the months across the top, the customers down the left side and then for each month, I want to show the count of each unique invoice.
This formula gives me the count for the month: =COUNTIFS(DA2023YTD[Sell-to Customer Name],$F9,DA2023YTD[Scheduled Shipment Date],">="&G$1,DA2023YTD[Scheduled Shipment Date],"<="&G$2), but since I have each product a part of this count, the result is incorrect.
Thanks for your help!!
I want to create a dynamic report that shows the months across the top, the customers down the left side and then for each month, I want to show the count of each unique invoice.
This formula gives me the count for the month: =COUNTIFS(DA2023YTD[Sell-to Customer Name],$F9,DA2023YTD[Scheduled Shipment Date],">="&G$1,DA2023YTD[Scheduled Shipment Date],"<="&G$2), but since I have each product a part of this count, the result is incorrect.
Thanks for your help!!