I want to show sum of columns but breakdown only one column by category

[adnankabina]

Hi this is in Excel . I have query it has all fields.  I want to show in visual like that. Breakdown of Units by category 

[amitchandak]

@adnankabina , The information you have provided is not making the problem clear to me. Can you please explain with an example.

if that is about custom total : P&L formatting right: https://youtu.be/C9K8uVfthUU

Appreciate your Kudos.

[adnankabina]

Hi I have query 

select Order Fullfilled,  Shorted_quantity, Actual Units, Commodity from tableA

This is I have created in Power bi  left side but I want result which i created in excel on right side in colors. I want that visual. I dont want to breakup by commodity by all column but only 1 column.