Hi all,
Having a bit of trouble with this, wondering if someone can help spot what I'm missing or misunderstanding.
The purpose of my saved search is to report on the top selling items. Here are the criteria and results.
When I look at my results, the numbers are way over what they should be.
The thing is, if I drill into the item everything seems to be correct. The quantity, amount, number of orders all add up to what they should be, which is different to what the summarized results show.
Can anyone help me understand why my grouped results are so inflated?
I've also tried removing most of the other columns and even using the criteria to filter it down to 1 item to see if something was being duplicated, but even at the bare minimum I'm still getting the same incorrect numbers.
It is still counting Document number correctly, but not summing quantity nor amount correctly.