topic Group by Month in QlikView https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/170870#M41111 <HTML><HEAD></HEAD><BODY><P>I do have sales numbers on year,month,salesperson.<BR />I want a pivottable with year,month,salesperson and percentage of sales.</P><P>Percentage of sales would be calculated on total sales per YearMonth per sales/total sales per YearMonth</P><P>The pivottable will contain more than 1 year.</P><P>Can anyone help me with the formula to aggregate this in the right way?</P></BODY></HTML> Mon, 23 Aug 2010 10:44:39 GMT 2010-08-23T10:44:39Z Group by Month https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/170870#M41111 <HTML><HEAD></HEAD><BODY><P>I do have sales numbers on year,month,salesperson.<BR />I want a pivottable with year,month,salesperson and percentage of sales.</P><P>Percentage of sales would be calculated on total sales per YearMonth per sales/total sales per YearMonth</P><P>The pivottable will contain more than 1 year.</P><P>Can anyone help me with the formula to aggregate this in the right way?</P></BODY></HTML> Mon, 23 Aug 2010 10:44:39 GMT https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/170870#M41111 2010-08-23T10:44:39Z SV:Group by Month https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/170871#M41112 <HTML><HEAD></HEAD><BODY><P>aggr(sum(salesmonth),salesperson) / aggr(sum(salesmonth),company)?</P></BODY></HTML> Mon, 23 Aug 2010 11:06:39 GMT https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/170871#M41112 2010-08-23T11:06:39Z