topic Re: Only Partial Sum on Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Only-Partial-Sum-on-Pivot-Table/m-p/390882#M145765 <HTML><HEAD></HEAD><BODY><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 27 Feb 2013 21:50:36 GMT farolito20 2013-02-27T21:50:36Z Only Partial Sum on Pivot Table https://community.qlik.com/t5/QlikView/Only-Partial-Sum-on-Pivot-Table/m-p/390880#M145763 <HTML><HEAD></HEAD><BODY><P>How can I show only partial sum, without a total sum on pivot table?</P></BODY></HTML> Wed, 27 Feb 2013 21:37:08 GMT https://community.qlik.com/t5/QlikView/Only-Partial-Sum-on-Pivot-Table/m-p/390880#M145763 farolito20 2013-02-27T21:37:08Z Re: Only Partial Sum on Pivot Table https://community.qlik.com/t5/QlikView/Only-Partial-Sum-on-Pivot-Table/m-p/390881#M145764 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>= if(RowNo() = 0 or IsNull(RowNo()),'', Sum(Sales))</P><P></P><P>In Presentation tab, Labels for Totals&nbsp; = ''</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 27 Feb 2013 21:47:45 GMT https://community.qlik.com/t5/QlikView/Only-Partial-Sum-on-Pivot-Table/m-p/390881#M145764 MayilVahanan 2013-02-27T21:47:45Z Re: Only Partial Sum on Pivot Table https://community.qlik.com/t5/QlikView/Only-Partial-Sum-on-Pivot-Table/m-p/390882#M145765 <HTML><HEAD></HEAD><BODY><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 27 Feb 2013 21:50:36 GMT https://community.qlik.com/t5/QlikView/Only-Partial-Sum-on-Pivot-Table/m-p/390882#M145765 farolito20 2013-02-27T21:50:36Z