I am trying to use the following table to make a bar chart where price/pc will be be shown according to the SKUs. However the chart is showing cumulative value for the SKU. For example, for SKU "10-15" of brand A the chart is showing a bar chart with value 7 (5+2). But I want two separate bars for this SKU since the same SKU has two different pack size (Pcs).
Please check the attached excel file with chart & pic where I showed which graph I wanted to prepare & what I got from tableau. Thanks