I’m trying to look at a report to show a decline in product sales by item code, but taking into account customers, not just global declines.
For example, ten customers may buy a product, 9 are increasing sales but the 10th is declining.
If the actual total sales are increasing this wouldn’t show in the report as it’s not declining, but i want to see the one customer that isn’t.
At the point I run the report, I won’t know which customer or product I want to look at, that’s the point of the report. It should basically give me a list of all declining lines by customer.