In SSRS 2008 R2, I have two separate but very similar matrices. Each is based on a separate dataset, and each dataset pulls from a separate SQL database.
Each matrix has two columns--Vendor ID and Monthly Purchases.
I want to join these two matrices into one. But, what if the same vendor is in each matrix? How do I join these two objects where vendors, as well as their Monthly Purchases amounts are combined (summed) seamlessly?
And, I'm going to have detail "drill-down" data for each matrix. If I combine them, will those drill-downs still work?