topic Re: Cross table, How do i calculate two totals? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295341#M837126 <HTML><HEAD></HEAD><BODY><P>Hi Avinash that looks right, But how would i apply it to my own table?</P><P></P><P>Would i need a PEEK function?</P><P></P><P>I just want The <SPAN style="text-decoration: underline;">totals of each ClothingGroup</SPAN>, divided by the <SPAN style="text-decoration: underline;">grand total</SPAN> in an expression/dimension for this new row underneath the totals</P></BODY></HTML> Thu, 18 May 2017 14:28:31 GMT aaronnayan 2017-05-18T14:28:31Z How to calculate this Row? https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295337#M837122 <HTML><HEAD></HEAD><BODY><P>Hi Everbody!</P><P></P><P>I need help in a Pivot table, i want to divide one clothing total by the grand month total</P><P></P><P><SPAN style="color: #000000; font-size: 13.3333px;">I want to calculate this (</SPAN><SPAN style="color: #ff0000; font-size: 13.3333px;">NEW %?? <SPAN style="color: #000000; font-size: 13.3333px;">row</SPAN><SPAN style="color: #000000;">) in my current table.&nbsp; for each product group.</SPAN></SPAN></P><P></P><P></P><P>Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tshirts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jeans&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hoodies&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month Total</P><P>Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&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; 17</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&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; 4&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; 18</P><P>March&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&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; 5&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>Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">&nbsp;&nbsp;&nbsp;&nbsp; 45 &lt; <SPAN style="font-size: 8pt;"><EM>Grand Month Total&nbsp; </EM></SPAN>&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #ff0000;">NEW %??&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16/45=%&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; ??</SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px;">I have tried creating a variable.</SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px;">Please ask for more information. Fast Responses. Please need help </SPAN></P><P><SPAN style="color: #000000; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN><SPAN style="color: #000000; font-size: 13.3333px;">Many thanks Qlik community </SPAN><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295337#M837122 aaronnayan 2020-11-25T16:16:04Z Re: Cross table, How do i calculate two totals? https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295338#M837123 <HTML><HEAD></HEAD><BODY><P>Can you share sample data, you can use pick function in&nbsp; dimensions and expressions to attain the above format.</P></BODY></HTML> Thu, 18 May 2017 14:12:35 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295338#M837123 Anonymous 2017-05-18T14:12:35Z Re: Cross table, How do i calculate two totals? https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295339#M837124 <HTML><HEAD></HEAD><BODY><P>Sorry Shiva i cannot share sample data, could you give me an example of the expression?</P></BODY></HTML> Thu, 18 May 2017 14:14:56 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295339#M837124 aaronnayan 2017-05-18T14:14:56Z Re: Cross table, How do i calculate two totals? https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295340#M837125 <HTML><HEAD></HEAD><BODY><P><EM>Check this </EM></P><P><EM><A href="https://community.qlik.com/thread/96467">Adding a calculated row to a pivot table</A></EM></P></BODY></HTML> Thu, 18 May 2017 14:20:40 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295340#M837125 avinashelite 2017-05-18T14:20:40Z Re: Cross table, How do i calculate two totals? https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295341#M837126 <HTML><HEAD></HEAD><BODY><P>Hi Avinash that looks right, But how would i apply it to my own table?</P><P></P><P>Would i need a PEEK function?</P><P></P><P>I just want The <SPAN style="text-decoration: underline;">totals of each ClothingGroup</SPAN>, divided by the <SPAN style="text-decoration: underline;">grand total</SPAN> in an expression/dimension for this new row underneath the totals</P></BODY></HTML> Thu, 18 May 2017 14:28:31 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-this-Row/m-p/1295341#M837126 aaronnayan 2017-05-18T14:28:31Z