So, you are thinking of making a visual to show the distribution of the various line items to the total within the category as well as overall categories

In our (beloved) superstore example, let’s say you want to see how one Sub-category is doing compared to others. In addition, you would like show often an order (or a customer) is providing profit for that sub category, consider a skyscraper graph

Here’s how to build one in 6 steps

Take “Sales” (or relevant metric) to Row

 

Take “Sub-category” (or the relevant dimension) to Columns

 

Take “Customer Name” (or the secondary dimension) to Detail

 

Add the metric (sales in this case) also to Size

 

Create a combined field for Primary and Secondary dimension and add it to detail

 

Add this field to the detail and sort it by your metric, change the Mark to be “Bars” instead of Automatic

 

Do a bit of formatting and you are done 🙂

Now, for bonus points, you can also add a beacon to your skyscraper using the WINDOW_SUM(SUM([Sales])) as another metric and making it a dual axis

And, you can make it look like this