Relative checkbox is not working

[Anonymous]

Hi,

I am trying to add two expression in one pivot table, I have displayed the type, count and count as relative:

Type                          Count               Count as relative

Type1                        208                   9.85%

Type2                        1470                 69.60%

Type3                        71                     3.36%

Type4                        170                   8.05%

Type5                        191                   9.04%

Type6                         2                      0.09%

Total                          1732                100%

That is the values of the tables, but if I divided 208/1732 = 12.01%

1470/1732*100= 84.88%

As you can see the numbers are not matching, how can I get the percentage working?

[sunny_talwar]

If I manually sum all the values for Type, I get 2112... so I think the calculation is 208/2112.... how are you getting a total of 1732?

[Anonymous · Accepted solution]

Using the Total Mode "Expression Total" but if I click on SUM, I got the correct data and the percentage is matching now.

[sunny_talwar]

So you managed to get 12.01%? Really?

[Anonymous]

No, I have as total 1732, so I guessed that the percentage was wrong, but now I identified that the problem was with the SUM