I think it's little bit difficult to explain on non-real data, but I will try.
I tool Sub-category as MFG parts # in you case.
And "State" as Supplier.
Using version 10.1
Self-Join the data with "Sub category", in your case, MFG Part ID.
Let me know if you need further clarifications.
Superstore_join_SM_10.1.twbx 413.5 KB
Hi Brittany ,
Create a calculated field for the count of MFG Part #
Count([MFG Part #])
Drag the variable MFG Part # to Rows and the Calculated field to rows.
Add Supplier's to color
Right click on the measures in the Column and select Percentage of Total. Compute this measure along Suppliers.
You will not get a stacked bar chart showing what percentage of supplier have bought a particular item.
Hope I was able to get what you meant. I used the following sample data