topic pivot table design in QlikView

topic pivot table design in QlikView https://community.qlik.com/t5/QlikView/pivot-table-design/m-p/420569#M1156545 <HTML><HEAD></HEAD><BODY><P>in the attached qvw file there is sheet named "not working" . How can i get meanA for each month. </P><P></P><P></P><P>month name                     meanA</P><P>dec 2012                             98</P><P>dec 2012                            100</P><P>nov 2012                             88</P></BODY></HTML> Mon, 14 Jan 2013 16:31:32 GMT 2013-01-14T16:31:32Z pivot table design https://community.qlik.com/t5/QlikView/pivot-table-design/m-p/420569#M1156545 <HTML><HEAD></HEAD><BODY><P>in the attached qvw file there is sheet named "not working" . How can i get meanA for each month. </P><P></P><P></P><P>month name                     meanA</P><P>dec 2012                             98</P><P>dec 2012                            100</P><P>nov 2012                             88</P></BODY></HTML> Mon, 14 Jan 2013 16:31:32 GMT https://community.qlik.com/t5/QlikView/pivot-table-design/m-p/420569#M1156545 2013-01-14T16:31:32Z Re: pivot table design https://community.qlik.com/t5/QlikView/pivot-table-design/m-p/420570#M1156546 <HTML><HEAD></HEAD><BODY><P>Into the expression you set </P><P><SPAN style="color: #0000ff; font-size: 8pt;">  </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>avg </P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MeanB</SPAN><SPAN style="font-size: 8pt;">)      not  </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">avg</SPAN><SPAN style="font-size: 8pt;">(m</SPAN><SPAN style="color: #800000; font-size: 8pt;">eanB</SPAN><SPAN style="font-size: 8pt;">) .</SPAN><P></P><P>Bye </P><P>Marco</P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 14 Jan 2013 16:42:10 GMT https://community.qlik.com/t5/QlikView/pivot-table-design/m-p/420570#M1156546 2013-01-14T16:42:10Z Re: pivot table design https://community.qlik.com/t5/QlikView/pivot-table-design/m-p/420571#M1156547 <HTML><HEAD></HEAD><BODY><P>AGGR(AVG(meanA),Month,Year)</P></BODY></HTML> Tue, 15 Jan 2013 12:01:33 GMT https://community.qlik.com/t5/QlikView/pivot-table-design/m-p/420571#M1156547 christian77 2013-01-15T12:01:33Z