topic Dimension in pivot table in QlikView https://community.qlik.com/t5/QlikView/Dimension-in-pivot-table/m-p/436580#M1162389 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I'm wondering if it is possible to use a calculated dimension into pivot table in the following way</P><P></P><P>Pivot tabel</P><P></P><P><STRONG>Customer&nbsp;&nbsp;&nbsp;&nbsp; TOTAL SALES</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; % of TOTALSALES</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&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; 10%</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&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; 20%</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&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; 50%</P><P>...</P><P></P><P>The table above has two dimensions: Customer and TOTAL SALES&nbsp; (aggr (sum(Sales), Customer)</P><P>How can I calculate the espressione % of TOTALE SALES ? Is it possible to use the dimension TOTAL SALES ?</P><P>I'm a bit confused. </P><P>Thanks in advance</P></BODY></HTML> Sun, 21 Oct 2012 22:16:38 GMT Anonymous 2012-10-21T22:16:38Z Dimension in pivot table https://community.qlik.com/t5/QlikView/Dimension-in-pivot-table/m-p/436580#M1162389 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I'm wondering if it is possible to use a calculated dimension into pivot table in the following way</P><P></P><P>Pivot tabel</P><P></P><P><STRONG>Customer&nbsp;&nbsp;&nbsp;&nbsp; TOTAL SALES</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; % of TOTALSALES</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&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; 10%</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&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; 20%</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&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; 50%</P><P>...</P><P></P><P>The table above has two dimensions: Customer and TOTAL SALES&nbsp; (aggr (sum(Sales), Customer)</P><P>How can I calculate the espressione % of TOTALE SALES ? Is it possible to use the dimension TOTAL SALES ?</P><P>I'm a bit confused. </P><P>Thanks in advance</P></BODY></HTML> Sun, 21 Oct 2012 22:16:38 GMT https://community.qlik.com/t5/QlikView/Dimension-in-pivot-table/m-p/436580#M1162389 Anonymous 2012-10-21T22:16:38Z Re: Dimension in pivot table https://community.qlik.com/t5/QlikView/Dimension-in-pivot-table/m-p/436581#M1162390 <HTML><HEAD></HEAD><BODY><P>Not sure why you want or need a calculated dimension for this ( I would use just an expression for TOTAL SALES, sum(Sales) ), but the % should look like this in both cases:</P><P></P><P>=sum(Sales) / sum(total Sales)</P><P></P><P>This gives different values than in your sample:</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.5 %</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25 %</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 62.5 %</P><P></P><P>but this looks correct for me (assuming a total Sales of 8000).</P><P></P><P>Stefan</P></BODY></HTML> Sun, 21 Oct 2012 22:25:44 GMT https://community.qlik.com/t5/QlikView/Dimension-in-pivot-table/m-p/436581#M1162390 swuehl 2012-10-21T22:25:44Z Re: Dimension in pivot table https://community.qlik.com/t5/QlikView/Dimension-in-pivot-table/m-p/436582#M1162391 <HTML><HEAD></HEAD><BODY><P>Hi, Stefan.</P><P></P><P>It's look like he've&nbsp; skipped "D - 2000 - 20%" <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 22 Oct 2012 20:06:41 GMT https://community.qlik.com/t5/QlikView/Dimension-in-pivot-table/m-p/436582#M1162391 whiteline 2012-10-22T20:06:41Z