topic Re: How to get sum column (each column) in pivot table ? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315413#M842061 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 25 Apr 2017 12:17:39 GMT sunny_talwar 2017-04-25T12:17:39Z How to get sum column (each column) in pivot table ? https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315410#M842058 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I need yours help</P><P>Please see this picture :</P><P>(<SPAN lang="en">Sorry, I think it's easier to talk through pictures)</SPAN><SPAN class="trans-verified-button goog-toolbar-button"><SPAN class="jfk-button-img"></SPAN></SPAN></P><P><IMG alt="a.jpg" class="jive-image image-1" height="173" src="https://community.qlik.com/legacyfs/online/161154_a.jpg" style="width: 771.65px; height: 173px;" width="772" /></P><P>Value 3 is sum value column day 1,2,5,6,7 and 8</P><P>not value from 500/600 = 0.83</P><P>Can I get value =3</P><P></P><P>Be Regards</P><P>Dani Pudianto</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315410#M842058 danipudianto 2020-11-25T16:16:04Z Re: How to get sum column (each column) in pivot table ? https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315411#M842059 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Sum(Aggr(sum(plan)/sum(cap*wd), subinv, day))</STRONG></P></BODY></HTML> Tue, 25 Apr 2017 12:09:08 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315411#M842059 sunny_talwar 2017-04-25T12:09:08Z Re: How to get sum column (each column) in pivot table ? https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315412#M842060 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P><P>It's Work !!</P></BODY></HTML> Tue, 25 Apr 2017 12:17:03 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315412#M842060 danipudianto 2017-04-25T12:17:03Z Re: How to get sum column (each column) in pivot table ? https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315413#M842061 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 25 Apr 2017 12:17:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-sum-column-each-column-in-pivot-table/m-p/1315413#M842061 sunny_talwar 2017-04-25T12:17:39Z