Average in pivot table not matching

[sunitha_chellaiah]

Hi All,

Average in my pivot table is not matching with the output which I want.

Same table which I export excel then I am getting the desired out.

I have attached the data. 

Desired output: 6,05...

But in Qlik I am getting : 6,17..

Please Help. Thanks.

[Frank_Hartmann · Accepted solution]

try like this:

Textbox:

=avg(aggr(Data,ID))