Drag sum(sales) onto the row shelf. Add your dimension to the column shelf. In this case, we’re using state.
Sort your states largest to smallest. Hold the control key down and copy your sales pill.
Add a quick table calculation for running total.
Open the table calculation and add a secondary calculation. Choose percent of total.
Change your row pills to a dual axis, and update your colors.