I follow this great post about how making a basket market analysis via a self join inside tableau (see here: http://kb.tableausoftware.com/articles/knowledgebase/market-basket-analysis).
The previous tutorial uses number of lines to display the result. I would like to display calculated Cross Revenue in addition to this metric.
For instance : if coffee (2€) has been sold with bread [1€), I would like to display at the intersection of coffee and bread (coffee on the row shelf / bread on the column shelf) 1€.
My dataset is as follow :
When summing the revenue measure, Tableau duplicates the result as self joining retrieve all possible combination at the product level.
I tried a calculated field something like TOTAL(SUM([Source$Revenue])/COUNTD([Products]) but I cannot make it work at the transactionID partition.
Any hints ?