topic Not aggregation by dimension in QlikView https://community.qlik.com/t5/QlikView/Not-aggregation-by-dimension/m-p/766940#M471977 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P>Is&nbsp; any way to solve such task.</P><P></P><P>I have pivot table with dimension Sales Point and YearMonth.</P><P></P><P></P><P>My expr: sum(Volume)/count(Distinct [Sales Point])</P><P>I need: sum(Volume) <STRONG>to aggregate</STRONG> by YearMonth,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count(Distinct [Sales Point]) <STRONG>not aggregate</STRONG> by YearMonth</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thanks.</SPAN></P></BODY></HTML> Mon, 09 Feb 2015 10:49:44 GMT Anonymous 2015-02-09T10:49:44Z Not aggregation by dimension https://community.qlik.com/t5/QlikView/Not-aggregation-by-dimension/m-p/766940#M471977 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P>Is&nbsp; any way to solve such task.</P><P></P><P>I have pivot table with dimension Sales Point and YearMonth.</P><P></P><P></P><P>My expr: sum(Volume)/count(Distinct [Sales Point])</P><P>I need: sum(Volume) <STRONG>to aggregate</STRONG> by YearMonth,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count(Distinct [Sales Point]) <STRONG>not aggregate</STRONG> by YearMonth</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thanks.</SPAN></P></BODY></HTML> Mon, 09 Feb 2015 10:49:44 GMT https://community.qlik.com/t5/QlikView/Not-aggregation-by-dimension/m-p/766940#M471977 Anonymous 2015-02-09T10:49:44Z Re: Not aggregation by dimension https://community.qlik.com/t5/QlikView/Not-aggregation-by-dimension/m-p/766941#M471978 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Perhaps sum(Volume)/count(total &lt;[Sales Point]&gt; Distinct [Sales Point])</SPAN></P></BODY></HTML> Mon, 09 Feb 2015 10:51:45 GMT https://community.qlik.com/t5/QlikView/Not-aggregation-by-dimension/m-p/766941#M471978 Gysbert_Wassenaar 2015-02-09T10:51:45Z Re: Not aggregation by dimension https://community.qlik.com/t5/QlikView/Not-aggregation-by-dimension/m-p/766942#M471979 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P>sum( Total &lt;[Sales Point]&gt; Volume)/count( Total &lt;YearMonth&gt; Distinct [Sales Point])</P></BODY></HTML> Mon, 09 Feb 2015 10:55:30 GMT https://community.qlik.com/t5/QlikView/Not-aggregation-by-dimension/m-p/766942#M471979 tresB 2015-02-09T10:55:30Z