Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anuhyak1
Creator
Creator

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

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.

 

Anuhyak1_0-1702606667038.png

 

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

Anuhyak1_1-1702606667048.png

 

2 Replies
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>))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anuhyak1
Creator
Creator
Author

Any other solutions please in Qliksense pivot table