Comparison of two values in a matrix

[mgantt87]

I am having trouble with the comaprison issue described below.  I have 2 tables (A & B in the example) joined by the column called Group.  The join is many in table A to one in table B.  Both table A and table B have a "type."  It is possible that the type from table A is not equal to the type from table B and when this happens I need to flag the record.  In the example, item 4 from table A shows a type of corn, but it is joined to table B as a fruit and table B has a type of apple, not corn, so this should flag (and conditional format) in the resulting matrix.  I would also like to flag it at the group level so that if the matrix is collapsed, the user can see that the data at the next level down is out of sync.

TableA:
Item	Type	Group
1	Apple	Fruit
2	Apple	Fruit
3	Apple	Fruit
4	Corn	Fruit
5	Corn	Vegetable
6	Corn	Vegetable

Table B:
Group	Type
Fruit	Apple
Vegetable	Corn

Table A & B are joined on Group.

Report (matrix):
Group		Type (from Table A)	Type (from Table B)	Flag
Fruit		Apple	Apple	1
	1	Apple	Apple	0
	2	Apple	Apple	0
	3	Apple	Apple	0
	4	Corn	Apple	1
Vegetable		Corn	Corn	0
	5	Corn	Corn	0
	6	Corn	Corn	0

[ryan_mayu · Accepted solution]

@mgantt87 

you can merge tables in PQ

then create a column

flag = if(TableA[Type in Table A]=TableA[Type in Table B],0,1)

pls see the attachment below