I need to compare revenue between products, but it seems like Market Basket approach is indeed what I want. So I performed the following steps as I'm using Tableau v9.1:
1) Done a legacy Extract
2) Paired Customer Number
3) "<>" on the product level I want to compare
4) My Shelf Is as follows: Column: Product Category (Z$1) - (SUM Sales (Z$1) --- Row: Product Category - (Sum sales)
5) I drag Customer Number to be displayed in the chart.
So the way I think this should work is that Tableau would sum sales for a product A for a customer number and then compare this to the sum of Product B sales for a customer number. The problem is that it the sums are non-nonsensically high. Furthermore the workbook is extremely slow live and if I extract, it doesn't look like it will ever finish (I get into the Billions of records). My base data set only has 17k rows.
Thoughts on where I'm going wrong? Thanks for the help!
I'm afraid this is going to be a bit hard to diagnose with out a workbook.
You could take a look at this thread: Market Basket in Tableau 9
There is a sample workbook on there. I dropped Sales on the crosstab marks card instead of number of records and it worked. There is also a heatmap view on there.
If you drop customer number on there, it is going to try and calculate the combinations for each customer for each customer which could explain why you are getting crazy results.