topic Re: Why does average change when expanded in pivot table? in QlikView https://community.qlik.com/t5/QlikView/Why-does-average-change-when-expanded-in-pivot-table/m-p/952758#M969062 <HTML><HEAD></HEAD><BODY><P>Please post your Dimension you are using on the Pivot Table.</P></BODY></HTML> Mon, 28 Sep 2015 20:24:00 GMT 2015-09-28T20:24:00Z Why does average change when expanded in pivot table? https://community.qlik.com/t5/QlikView/Why-does-average-change-when-expanded-in-pivot-table/m-p/952756#M969060 <HTML><HEAD></HEAD><BODY><P>Good afternoon,</P><P></P><P>I have an expression like this using aggr in a pivot table : avg(aggr(sum(NETWIN),LLAVE)) , when it´s not expanded doesn´t make the average well but if I expand it and export the detail to excel I calculate the average and it is ok, do you know why does it happen?</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 28 Sep 2015 20:18:16 GMT https://community.qlik.com/t5/QlikView/Why-does-average-change-when-expanded-in-pivot-table/m-p/952756#M969060 2015-09-28T20:18:16Z Re: Why does average change when expanded in pivot table? https://community.qlik.com/t5/QlikView/Why-does-average-change-when-expanded-in-pivot-table/m-p/952757#M969061 <HTML><HEAD></HEAD><BODY><P>Its depend on Your Dimension Values.</P></BODY></HTML> Mon, 28 Sep 2015 20:23:06 GMT https://community.qlik.com/t5/QlikView/Why-does-average-change-when-expanded-in-pivot-table/m-p/952757#M969061 2015-09-28T20:23:06Z Re: Why does average change when expanded in pivot table? https://community.qlik.com/t5/QlikView/Why-does-average-change-when-expanded-in-pivot-table/m-p/952758#M969062 <HTML><HEAD></HEAD><BODY><P>Please post your Dimension you are using on the Pivot Table.</P></BODY></HTML> Mon, 28 Sep 2015 20:24:00 GMT https://community.qlik.com/t5/QlikView/Why-does-average-change-when-expanded-in-pivot-table/m-p/952758#M969062 2015-09-28T20:24:00Z