I need this to be done in SSRS. In SSRS, I have one dataset that feeds into two matrix/tables.
TableA displays Field1 and Field2.
TableB displays Field1 and Field3.
Only make TableB visible if TableA has letter "B" in it.
I have tried LookUp, LookUpSet, MultiLookUp, CountDistinct, and a bunch of other aggregated functions. CountDistinct seems to work because it returns back 3 counts.