topic Partial Sum to Exclude line item in QlikView https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208657#M588402 <HTML><HEAD></HEAD><BODY><P>Thank you!! Just the solution I was looking for <IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P><P></P></BODY></HTML> Sun, 19 Sep 2010 20:15:01 GMT 2010-09-19T20:15:01Z Partial Sum to Exclude line item https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208653#M588398 <HTML><HEAD></HEAD><BODY><P>&lt;body&gt;&lt;p&gt;Hello All,&lt;/p&gt; &lt;p&gt;I am creating a chart where I am reporting sales for Team,Supervisor and Team members. &lt;/p&gt; &lt;p&gt;Because a supervisor is a member of a team , supervisors sales will also have sales to be reported. &lt;/p&gt; &lt;p&gt;I have a requirement that I should be able to exclude supervisor's sales from team total.&nbsp;&lt;/p&gt; &lt;p&gt;How do I achieve this? Is this possible using partial sums? If yes , How? Please help.&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&lt;col width="39"&gt;&lt;/col&gt;&lt;col width="67"&gt;&lt;/col&gt;&lt;col width="125"&gt;&lt;/col&gt;&lt;col width="40"&gt;&lt;/col&gt; &lt;tr height="17"&gt; &lt;td height="17"&gt;&lt;/td&gt; &lt;td class="xl22"&gt;&lt;br /&gt;&lt;/td&gt; &lt;td class="xl22"&gt;&lt;br /&gt;&lt;/td&gt; &lt;td class="xl22" align="right" x:fmla="=SUM(D2:D6)"&gt;&lt;br /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt;&lt;/body&gt;</P></BODY></HTML> Sun, 19 Sep 2010 18:59:01 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208653#M588398 2010-09-19T18:59:01Z Partial Sum to Exclude line item https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208654#M588399 <HTML><HEAD></HEAD><BODY><P>Pranita,</P><P>See attached solution.</P><P>Regards,</P></BODY></HTML> Sun, 19 Sep 2010 19:15:28 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208654#M588399 vgutkovsky 2010-09-19T19:15:28Z Partial Sum to Exclude line item https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208655#M588400 <HTML><HEAD></HEAD><BODY><P>Vlad,</P><P>What i need is to exclude supervisor's sales from the total. Therefore the total for the supervisor should come out at 60 and not 75. However for the team 75 is the correct number.</P><P>any other solution???</P><P></P></BODY></HTML> Sun, 19 Sep 2010 19:39:51 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208655#M588400 2010-09-19T19:39:51Z Partial Sum to Exclude line item https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208656#M588401 <HTML><HEAD></HEAD><BODY><P>Oops, sorry (misread your original post). Here's an updated version.</P><P>Cheers,</P></BODY></HTML> Sun, 19 Sep 2010 19:59:56 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208656#M588401 vgutkovsky 2010-09-19T19:59:56Z Partial Sum to Exclude line item https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208657#M588402 <HTML><HEAD></HEAD><BODY><P>Thank you!! Just the solution I was looking for <IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P><P></P></BODY></HTML> Sun, 19 Sep 2010 20:15:01 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-to-Exclude-line-item/m-p/208657#M588402 2010-09-19T20:15:01Z