Good morning,
I am looking for a solution to a little issue, I have a transaction history report that I run where I sum/count the QTY produced by week and by commodity type, however, currently I have to run the report then save the sum as a value and remove duplicate part numbers to get a unique count. I have used a sum if freq before to get unique counts but not with additional criteria and I cannot seem to make it work for this case.
I have uploaded a sample of the data and a sample of what my sum/count looks like.
Any help would be appreciated.
Bookmarks