https://community.qlik.com/t5/QlikView/Average-in-pivot-table-not-matching/m-p/1610607#M507796 <P>try like this:</P><P>Textbox:</P><P>=avg(aggr(Data,ID))</P> Thu, 08 Aug 2019 10:26:56 GMT Frank_Hartmann 2019-08-08T10:26:56Z https://community.qlik.com/t5/QlikView/Average-in-pivot-table-not-matching/m-p/1610599#M507795 <P>Hi All,</P><P>Average in my pivot table is not matching with the output which I want.</P><P>Same table which I export excel then I am getting the desired out.</P><P>I have attached the data.&nbsp;</P><P>Desired output: 6,05...</P><P>But in Qlik I am getting : 6,17..</P><P>Please Help. Thanks.</P><P>&nbsp;</P> Thu, 08 Aug 2019 10:18:27 GMT https://community.qlik.com/t5/QlikView/Average-in-pivot-table-not-matching/m-p/1610599#M507795 sunitha_chellaiah 2019-08-08T10:18:27Z https://community.qlik.com/t5/QlikView/Average-in-pivot-table-not-matching/m-p/1610607#M507796 <P>try like this:</P><P>Textbox:</P><P>=avg(aggr(Data,ID))</P> Thu, 08 Aug 2019 10:26:56 GMT https://community.qlik.com/t5/QlikView/Average-in-pivot-table-not-matching/m-p/1610607#M507796 Frank_Hartmann 2019-08-08T10:26:56Z