Calling all tableau geniuses!
I have a question regarding running totals which I was hoping you might be able to help me with.
Please find attached a package workbook containing some anonymized data.
I have three manufacturers, each you produce a range of standardised products, some available in different formats.
Over a period of time, I have a large number of customers who have purchased various products from the manufacturers.
I would like to analyse the cross purchase relationship between the different products.
For example, do the customers who purchase product 1, type 1 from manufacturer 1 subsequently purchase a disproportionate amount of product 5, type 11 from manufacturer 3?
One way I thought I could do this is to:
sort product 1, type 1 largest to smallest vertically
calculate the running total, and the percentage of total running down table
where product 1, type 1 hits 100%, compare percentage of revenue for other manufacturers/products
this would tell you that the customers that purchased 100% of product 1, type 1, also bought 15.3% of product 5, type 15 from manufacturer 1 or 10.79% of product 1, type 1 from manufacturer 2.
I would like to set this up in a table to compare easily, but I find I have to rework the above procedure for every product type. There must be a way to use the parameter controls to compare one product against another without having to start over each time. Any ideas?
I would like to present this data graphically, possibly with some running total Pareto type charts where one can easily identify the products that seem to have a relationship between manufacturers.
See sheet 3: my trouble is that I would like to be able to cycle through which product is "taken to 100%" to compare against the other products. I would also like to "cut it off" at 100%, to prevent the long tails.
Any help the community can offer on this little problem?
Very much appreciated!
running total question.twbx 434.3 KB