Pivot table cannot display total value

[#1]

Hi community,

My pivot table cannot display total value in Qlik Sense.

The data structure is shown below.

Type1	Type2	Value1	Value2
A	X	1	8
B	Y	5	6
C	Y	5	6
D	Z	7	9

From below pivot table, the total of aggr(max(Value1),Type1, Type2) should be 13. However, it cannot display value.

Does anyone help me on this? Thanks.

[sunny_talwar]

Try this expression:

=Sum(Aggr(Max(Value1),Type1, Type2))

[#3]

Hi Sunny

If I use Sum(Aggr(Max(Value1),Type1, Type2)), the total value of Y is 10 instead of 5. 

[sunny_talwar · Accepted solution]

Try this:

=Sum(Aggr(Only(Aggr(Max(Value1), Type1, Type2)), Type2))

[#5]

Sunny, Thank you very much for your help.

[sunny_talwar]

Not a problem

I am glad I was able to help.

Best,

Sunny