2 Replies Latest reply on Dec 18, 2015 9:44 PM by Raoul Leblanc

# different Percent of Total on different axes

I am trying to create a scatter plot in Tableau.  I have created an excel workbook with some dummy data and a viz.  I have attached both.

Here is what I am trying to do:  imagine you have three stores (A,B,C) and they sell three products (footballs, basketballs, and baseballs).  I want to make a graph that shows, as per below

that shows

1. along the y-axis, the football sales of each store as a % of the total football sales from all three stores.  In other words, what is the level of reliance for total football sales of each store.   I can make this one in my twbx.

2. along the x-axis, footballs as a % of the sales of each store.  In other words, what is the level of reliance/exposure to footballs sales of each store.  I cannot figure how to do this, much less still retain the other one as correct.

Importantly, I do not want any other marks in the analysis.  My "real" data already has a large number of marks and filtering down seems to throw off everything.  Also, I want these on the same viz, if possible, not as two half-viz's put together in a dashboard

Any suggestions?  Thanks.

Raoul

• ###### 1. Re: different Percent of Total on different axes

Hi Raoul,

Here's my take on solving that question. I removed your quick filter to allow the total sales value to be accessed and then calculated each store's reliance on footballs using a level of detail calculation. The y-axis is the same percent of total table calculation you had before, and the x-axis is the proportion of each store's football sales to each store's overall sales (references the LOD calculation).

The sample workbook is attached, as well as pictures below verifying that the percentages shown are correct.

Verification of percentages:

Graph showing percentages:

Best of luck!

Elliott Stam - InterWorks

• ###### 2. Re: different Percent of Total on different axes

Excellent.  I was able to recreate in my big workbook.  Thanks so much for the help in learning some useful formulae.