Hi folks, I'm trying to create a saved search to s...
# suiteanalytics
g
Hi folks, I'm trying to create a saved search to show if there are sales orders with duplicated items, I added the following columns: My idea is that the search shows how many items there are of each part number, but I only see results like this: Does anyone have an idea if I can create a saved search to show how many items there are of each part number?
g
You could try a Formula (Numeric) with MAX summary, using:
COUNT({item})
If I remember correctly, the COUNT summary is actually COUNT DISTINCT.
👍 1
g
It works 🙂 Thank you so much for your help
👍 1