Unique product count (summary)
I have a list, where I have subsummaries by product, month and day.
I am having a problem to separate unique products, that is, I have 46 products and they occur in 118 transactions. I created a summary field, where I put a total of product ID, but it didn't do the trick, it still displayed that 118, because it just counted number of fields having ID without removing multiple occurences of the same product in different transactions.
I also want this number to update depending if I choose to sort by current month or by date, just like Total SUM of all products does.
So how do I get the exact number (sum) of unique products to show up properly?