How to fix group by logic in subquery?

I have the following 2 example queries plus their result tables (dummy data) below:

SELECT
        subs.Region
        ,subs.Product
        ,SUM(p.Price) TotalPriceA
    FROM dbo.submission_dtl subs
    JOIN dbo.price_dtl p ON subs.SubmissionNumber = p.SubmissionNumber
    GROUP BY subs.Region, subs.Product

SELECT
            r.Region
            ,r.Product
            ,SUM(rp.Price) TotalPriceB
        FROM dbo.report_dtl r
        JOIN dbo.report_price rp ON r.SubmissionNumber = rp.SubmissionNumber
        GROUP BY r.Region, rp.Product

I want to join them so that the result table resembles this:

But when I used this query, I got a result table that resembled this:

SELECT
            subs.Region
            ,subs.Product
            ,SUM(p.Price) TotalPriceA
            ,rptotal.TotalPriceB
        FROM dbo.submission_dtl subs
        JOIN dbo.price_dtl p ON subs.SubmissionNumber = p.SubmissionNumber
        JOIN 
            (
               SELECT
                r.Product
                ,SUM(rp.Price) TotalPriceB
            FROM dbo.report_dtl r
            JOIN dbo.report_price rp ON r.SubmissionNumber = rp.SubmissionNumber
            GROUP BY rp.Product
            ) rptotal on subs.Product = rptotal.Product
        GROUP BY subs.Region, subs.Product, rptotal.TotalPriceB

When I group the subquery by region as well, I get even worse results…

>Solution :

You can try to use two subquery before join

SELECT t1.Region,
       t1.Product,
       t2.TotalPriceA,
       t1.TotalPriceB
FROM (
    SELECT
        r.Region
        ,r.Product
        ,SUM(rp.Price) TotalPriceB
    FROM dbo.report_dtl r
    JOIN dbo.report_price rp ON r.SubmissionNumber = rp.SubmissionNumber
    GROUP BY r.Region, rp.Product
) t1 INNER JOIN (
    SELECT
        subs.Region
        ,subs.Product
        ,SUM(p.Price) TotalPriceA
    FROM dbo.submission_dtl subs
    JOIN dbo.price_dtl p ON subs.SubmissionNumber = p.SubmissionNumber
    GROUP BY subs.Region, subs.Product
) t2 ON t1.Region = t2.Region AND t1.Product = t2.Product