QS: Pivot Table Default Total showing wrong when collapsing. Help with expression

[Anuhyak1]

In the below pivot table I am getting wrong default totals. Please help me to fix the issue.

Here is the expression used in Measure

Sum(if ( [Sending Area Name] = [Fac Area Name] ,1))

Here is the wrong totals when collapsing. It is showing one off in BI and one off in CA.

Here are the correct Totals = 1832  and the Value for I  should be = is 623 and N = 128 when expanding 

[Anil_Babu_Samineni]

I have learnt recently; this seems the nature is like this. To get accurate, you have to do something like this.

Sum(Aggr(Sum(if ( [Sending Area Name] = [Fac Area Name] ,1)), <All your dimensions in Pivot should be added with comma separated>))

[Anuhyak1]

Any other solutions please in Qliksense pivot table