Calculating a total column from 2 tables

Hi 

I am creating the below table from 2 data tables. They are linked via a 'Sales status' column and product column via 2 other tables with a list of sales staus, and products. . I cannot however create a total count of all sales by status. Can you advise why this

I want

                           Sales status 1                                        Sales status 2

Product 1          total count from source 1&2            total count from source 1&2

Product 2

Using the matrix feature i just get the figures seperated out.

Thanks

Emma