https://community.qlik.com/t5/QlikView/Avg-in-pivot-table-as-a-single-column/m-p/1525217#M440935 <P>Hi Folks,</P><P>I need to display avg as a new column on Pivot table,&nbsp; i am adding qvw as a sample and result as follows.</P><P>avg&nbsp; =&nbsp; sum(L12 Total)/count(weeks)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2835iE16476D3841F0747/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P> Tue, 01 Jan 2019 17:21:41 GMT rajaqliks 2019-01-01T17:21:41Z https://community.qlik.com/t5/QlikView/Avg-in-pivot-table-as-a-single-column/m-p/1525217#M440935 <P>Hi Folks,</P><P>I need to display avg as a new column on Pivot table,&nbsp; i am adding qvw as a sample and result as follows.</P><P>avg&nbsp; =&nbsp; sum(L12 Total)/count(weeks)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2835iE16476D3841F0747/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P> Tue, 01 Jan 2019 17:21:41 GMT https://community.qlik.com/t5/QlikView/Avg-in-pivot-table-as-a-single-column/m-p/1525217#M440935 rajaqliks 2019-01-01T17:21:41Z https://community.qlik.com/t5/QlikView/Avg-in-pivot-table-as-a-single-column/m-p/1541819#M440936 create new expression for Average<BR />=Column(1)/ Count(weeks) Fri, 08 Feb 2019 22:03:39 GMT https://community.qlik.com/t5/QlikView/Avg-in-pivot-table-as-a-single-column/m-p/1541819#M440936 bharathadde 2019-02-08T22:03:39Z