topic Pivot Table - Subtract between two rows in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637710#M233826 <HTML><HEAD></HEAD><BODY><P>Say if I have a Pivot table with two rows for given dimension, once I enable Partial Sums on the dimension I can see the sum of two rows. Is there any easy way to see the differences (Partial Subtraction) between two rows?</P><P></P><P>Thanks,</P><P>Mani.</P></BODY></HTML> Mon, 19 May 2014 08:58:28 GMT 2014-05-19T08:58:28Z Pivot Table - Subtract between two rows https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637710#M233826 <HTML><HEAD></HEAD><BODY><P>Say if I have a Pivot table with two rows for given dimension, once I enable Partial Sums on the dimension I can see the sum of two rows. Is there any easy way to see the differences (Partial Subtraction) between two rows?</P><P></P><P>Thanks,</P><P>Mani.</P></BODY></HTML> Mon, 19 May 2014 08:58:28 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637710#M233826 2014-05-19T08:58:28Z Re: Pivot Table - Subtract between two rows https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637711#M233827 <HTML><HEAD></HEAD><BODY><P>What do you want to do if you have more than two rows in a group?</P></BODY></HTML> Mon, 19 May 2014 09:17:40 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637711#M233827 anbu1984 2014-05-19T09:17:40Z Re: Re: Pivot Table - Subtract between two rows https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637712#M233828 <HTML><HEAD></HEAD><BODY><P>Try like this</P></BODY></HTML> Mon, 19 May 2014 09:30:38 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637712#M233828 anbu1984 2014-05-19T09:30:38Z Re: Pivot Table - Subtract between two rows https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637713#M233829 <HTML><HEAD></HEAD><BODY><P>Many Thanks Anbu ! This worked !</P></BODY></HTML> Mon, 19 May 2014 11:11:59 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Subtract-between-two-rows/m-p/637713#M233829 2014-05-19T11:11:59Z