topic Re: Sub total in pivot table in QlikView https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/891124#M1002445 <HTML><HEAD></HEAD><BODY><P>a sample app would help</P></BODY></HTML> Mon, 15 Jun 2015 09:40:18 GMT giakoum 2015-06-15T09:40:18Z Sub total in pivot table https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/891123#M1002443 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a pivot table which will show my monthly sales.</P><P>I have the partial sums(Total)option enabled.</P><P>I have to display background color by comparind the monthly sales against goal1 and for the toal sum column alone i have to compare against another field (Goal2).</P><P></P><P>I tried removing the partial sums and created a calculated dimension.</P><P>But i am not able to get the total which i am looking for.</P><P>Note : Sales is a division value(eg. A/B)</P><P></P><P>Could anyone help me on this by suggesting alternate ways.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 15 Jun 2015 09:36:12 GMT https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/891123#M1002443 Anonymous 2015-06-15T09:36:12Z Re: Sub total in pivot table https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/891124#M1002445 <HTML><HEAD></HEAD><BODY><P>a sample app would help</P></BODY></HTML> Mon, 15 Jun 2015 09:40:18 GMT https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/891124#M1002445 giakoum 2015-06-15T09:40:18Z