Grand total values in tableau files don't match on replicating Custom SQL Query based data source into PostGreSQL based data source.

Hi all,

I have 2 different twbx files.

One uses 2 custom SQL queries as a data source that are connected to each other using a '=' relationship operator on key1 and key2 from Custom SQL Query 1 and Custom SQL Query 2.

This twbx file gives me below result:

The other twbx file uses the PostGreSQL view as a data source which is a replica of the 2 custom SQL queries created using an inner join (Please correct me if inner join would be correct equivalent choice of '=' operator) on key1 and key 2 in the database. This twbx file gives me below result for the same records in the above screenshot:

The Grand Total as it can be seen is correct in the 2nd screenshot and is incorrect in the 1st screenshot. But the Grand Total values that I get in the 1st screenshot are correct for my usecase. I was trying to get the same grand total results in my twbx file that uses PostGreSQL as the data source. Any idea where I can be going wrong?

Thanks in advance for any help :)