Forum Discussion
Pivot Table or some other way to solve this issue?
Problem: I want to create a list of all accounts that have ordered 1-3 pallets in the last 12 months of Product A but have also ordered 20 or more pallets of Product B in the last twelve months. W...
I'm sorry if I didn't make myself clear, I was wondering if you could share some example records of the data you are trying to summarize, not of the query itself. As I do not have access to your data the query does not help much :-)
Hi Jan,
I fully understand your answer to Dan and it seems to me that it is up to him to provide a sample of data to solve his problem.
Not providing data, I imagined a dataset that could do the trick.
In the example in attachment, you will find the starting data and the result and I have commented the query.
Let me know if that was helpfull