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
