data in stacked bar format

[sanjanarama]

I have tables as below and created measures for each tables.

first three tables belong to company M and next three with company IQ.

I wanted to display the measure in stacked bar chart as above with company name as category. how can we do that ??

Table name	Measure name
M-IDMismatch
	CountOfTableM-IDMismatch
M-NameMismatch
	CountOfTableM-NameMismatch
M-NameMismatch
	CountOfTableM-NameMismatch
IQ-IDMismatch
	CountOfTableIQ-IDMismatch
IQ-NameMismatch
	CountOfTableIQ-NameMismatch
IQ-NameMismatch
	CountOfTableIQ-NameMismatch

[sanjanarama · Accepted solution]

I created new columns mentioning each company name, and merged all tables. then i was able to add the data into stacked bar graph with catergory