topic Re: Re: Subtotal in streight table in QlikView https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482394#M180278 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>It is not the solution you wanted but it mimics the format you wanted... </P><P></P><P>Sean</P></BODY></HTML> Thu, 09 Jan 2014 15:09:35 GMT 2014-01-09T15:09:35Z Subtotal in streight table https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482389#M180273 <HTML><HEAD></HEAD><BODY><P><BR />Hello,</P><P></P><P>I am having dataset like Category, commodity and Amount. Single category contains multiple commodities. I have created streight table showing top 10 Categories with sum(Amount), % of Total (% of each category Vs. Grand total of all categories). Also showing Dimension Subtotal (Grand total) and expression subtotal (Total) as showing in below image.</P><P></P><P><IMG alt="1.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/51240_1.jpg" /></P><P></P><P>My question: Can I promot Total one step above and Demot Grand total one step below ?</P></BODY></HTML> Wed, 08 Jan 2014 15:03:04 GMT https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482389#M180273 amayuresh 2014-01-08T15:03:04Z Re: Subtotal in streight table https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482390#M180274 <HTML><HEAD></HEAD><BODY><P>Hi Mayuresh</P><P></P><P>can you post the qvw ?</P><P></P><P>Chris</P></BODY></HTML> Wed, 08 Jan 2014 15:18:08 GMT https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482390#M180274 2014-01-08T15:18:08Z Re: Subtotal in streight table https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482391#M180275 <HTML><HEAD></HEAD><BODY><P>I will do it</P></BODY></HTML> Wed, 08 Jan 2014 15:21:43 GMT https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482391#M180275 amayuresh 2014-01-08T15:21:43Z Re: Subtotal in streight table https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482392#M180276 <HTML><HEAD></HEAD><BODY><P>Please find qvd and qvw files for above questions.</P></BODY></HTML> Thu, 09 Jan 2014 12:05:45 GMT https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482392#M180276 amayuresh 2014-01-09T12:05:45Z Re: Subtotal in streight table https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482393#M180277 <HTML><HEAD></HEAD><BODY><P>Sorry Mayuresh</P><P></P><P>I tried some tips but unable to find a solution</P><P></P><P>Let me know when you get it</P><P></P><P>Best regards</P><P>Chris</P></BODY></HTML> Thu, 09 Jan 2014 14:15:37 GMT https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482393#M180277 2014-01-09T14:15:37Z Re: Re: Subtotal in streight table https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482394#M180278 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>It is not the solution you wanted but it mimics the format you wanted... </P><P></P><P>Sean</P></BODY></HTML> Thu, 09 Jan 2014 15:09:35 GMT https://community.qlik.com/t5/QlikView/Subtotal-in-streight-table/m-p/482394#M180278 2014-01-09T15:09:35Z