Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attached is a simple data set with only 3 dimensions: Transaction, Category, and Sales. Each transaction can have multiple categories in it, and I want to perform a basket analysis looking at the average sales when a transaction includes a particular category. So for example, while the table pictured below shows that $12,931 in Category Z0 sales occurred across all 57,663 transactions that it was a part of, I want to show what the total sales were across all of those 57,663 transactions that had Z0 in them - including the sales of all of the other categories that were in those transactions as well. How could I best accomplish this?
Thanks,
Jeff
Not for the faint at heart. See attached qvw.
Not for the faint at heart. See attached qvw.
Wow, perfect! Going to take me a bit to digest how all of that code works but once I do this'll be great to learn from. Thanks Gysbert
Jeff