topic Two dimension pivot table and percentage in QlikView https://community.qlik.com/t5/QlikView/Two-dimension-pivot-table-and-percentage/m-p/553573#M206831 <HTML><HEAD></HEAD><BODY><P>I am trying to find percentage that percentage of sales of particular product out of total country sales</P><P></P><P>A - Country</P><P>B- Sales</P><P></P><P>I have used the following expression</P><P></P><P>aggr(sum(Sales),A,B)/aggr(sum(Sales),A)</P><P></P><P>Both of them are normal dimensions (not calculated)</P><P></P><P>I have attached excel of pivot the expression</P></BODY></HTML> Mon, 23 Sep 2013 09:19:14 GMT 2013-09-23T09:19:14Z Two dimension pivot table and percentage https://community.qlik.com/t5/QlikView/Two-dimension-pivot-table-and-percentage/m-p/553573#M206831 <HTML><HEAD></HEAD><BODY><P>I am trying to find percentage that percentage of sales of particular product out of total country sales</P><P></P><P>A - Country</P><P>B- Sales</P><P></P><P>I have used the following expression</P><P></P><P>aggr(sum(Sales),A,B)/aggr(sum(Sales),A)</P><P></P><P>Both of them are normal dimensions (not calculated)</P><P></P><P>I have attached excel of pivot the expression</P></BODY></HTML> Mon, 23 Sep 2013 09:19:14 GMT https://community.qlik.com/t5/QlikView/Two-dimension-pivot-table-and-percentage/m-p/553573#M206831 2013-09-23T09:19:14Z Re: Two dimension pivot table and percentage https://community.qlik.com/t5/QlikView/Two-dimension-pivot-table-and-percentage/m-p/553574#M206832 <HTML><HEAD></HEAD><BODY><P>B is product type not sales</P></BODY></HTML> Mon, 23 Sep 2013 09:20:38 GMT https://community.qlik.com/t5/QlikView/Two-dimension-pivot-table-and-percentage/m-p/553574#M206832 2013-09-23T09:20:38Z Re: Two dimension pivot table and percentage https://community.qlik.com/t5/QlikView/Two-dimension-pivot-table-and-percentage/m-p/553575#M206833 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/55650">Pivot table with two dimensions, calculation question</A></P></BODY></HTML> Mon, 23 Sep 2013 12:13:00 GMT https://community.qlik.com/t5/QlikView/Two-dimension-pivot-table-and-percentage/m-p/553575#M206833 2013-09-23T12:13:00Z