topic Cross Tab/Pivot with Additional Measurements? in QlikView https://community.qlik.com/t5/QlikView/Cross-Tab-Pivot-with-Additional-Measurements/m-p/707161#M254811 <HTML><HEAD></HEAD><BODY><P>Our customer wants to see a combination of measurements for their key dimensions.&nbsp; These would include monthly details (pivot month) but also contain yearly averages, and other total measures.&nbsp; For example, here is a pivot format:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales for Month(Jan-Dec)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Average Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Measure 1&nbsp;&nbsp; Measure 2&nbsp;&nbsp; Measure 3</P><P>Region</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; State</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; District</P><P></P><P></P><P>Is there an easy solution to get the monthly Sales in a pivot and still add Average Sales, Measure 1-3 (not monthly contributions)?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 16 Sep 2014 11:00:24 GMT 2014-09-16T11:00:24Z Cross Tab/Pivot with Additional Measurements? https://community.qlik.com/t5/QlikView/Cross-Tab-Pivot-with-Additional-Measurements/m-p/707161#M254811 <HTML><HEAD></HEAD><BODY><P>Our customer wants to see a combination of measurements for their key dimensions.&nbsp; These would include monthly details (pivot month) but also contain yearly averages, and other total measures.&nbsp; For example, here is a pivot format:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales for Month(Jan-Dec)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Average Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Measure 1&nbsp;&nbsp; Measure 2&nbsp;&nbsp; Measure 3</P><P>Region</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; State</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; District</P><P></P><P></P><P>Is there an easy solution to get the monthly Sales in a pivot and still add Average Sales, Measure 1-3 (not monthly contributions)?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 16 Sep 2014 11:00:24 GMT https://community.qlik.com/t5/QlikView/Cross-Tab-Pivot-with-Additional-Measurements/m-p/707161#M254811 2014-09-16T11:00:24Z Re: Cross Tab/Pivot with Additional Measurements? https://community.qlik.com/t5/QlikView/Cross-Tab-Pivot-with-Additional-Measurements/m-p/707162#M254812 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">For the measures Average Sales, Measure 1-3 you need to use AGGR() function,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">for example: Average Sales might be: Avg(Aggr(Sales,Region, State, District))<BR /></SPAN></P></BODY></HTML> Tue, 16 Sep 2014 11:07:48 GMT https://community.qlik.com/t5/QlikView/Cross-Tab-Pivot-with-Additional-Measurements/m-p/707162#M254812 Anonymous 2014-09-16T11:07:48Z