topic Total in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table/m-p/734383#M1064312 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am having some product which associated to CAT 1 or 2 or both. Now I want to show two charts, one for PRD1 which associated to CAT1 and another one which associated to CAT2. When I am doing this then expression showing total sum but I want individual sum like left side table in below image. Please suggest.</P><P><IMG alt="test.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67139_test.png" style="width: 620px; height: 173px;" /></P></BODY></HTML> Thu, 18 Sep 2014 17:10:06 GMT soha1902 2014-09-18T17:10:06Z Total in Pivot Table https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table/m-p/734383#M1064312 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am having some product which associated to CAT 1 or 2 or both. Now I want to show two charts, one for PRD1 which associated to CAT1 and another one which associated to CAT2. When I am doing this then expression showing total sum but I want individual sum like left side table in below image. Please suggest.</P><P><IMG alt="test.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67139_test.png" style="width: 620px; height: 173px;" /></P></BODY></HTML> Thu, 18 Sep 2014 17:10:06 GMT https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table/m-p/734383#M1064312 soha1902 2014-09-18T17:10:06Z Re: Total in Pivot Table https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table/m-p/734384#M1064313 <HTML><HEAD></HEAD><BODY><P>Your 2 tables are not joined, so summing Sal against against PRD1 or PRD2 gives you the misleading Cartesian join.</P></BODY></HTML> Thu, 18 Sep 2014 17:17:33 GMT https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table/m-p/734384#M1064313 Anonymous 2014-09-18T17:17:33Z