topic Re: help with custom cummulation in pivot table in QlikView https://community.qlik.com/t5/QlikView/help-with-custom-cummulation-in-pivot-table/m-p/705884#M254471 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Thu, 19 Jun 2014 13:06:10 GMT Gysbert_Wassenaar 2014-06-19T13:06:10Z help with custom cummulation in pivot table https://community.qlik.com/t5/QlikView/help-with-custom-cummulation-in-pivot-table/m-p/705883#M254470 <HTML><HEAD></HEAD><BODY><P>Dears </P><P>working on defects analysis in a software issue tracker system</P><P>I have defects for each release , defects can have as Defect_detection_Phase either&nbsp; pre_release or post_release</P><P>and if the defect is post_release then the column that is called Release_Phase will be equal to Release &amp; '-PR'</P><P></P><P>in the attached qvw I have a pivot table showing the count of backported defects by fixt period, release and release phase</P><P>the first expression is very fine</P><P>what I want in the second expression is to show on the release_phase (first one) the count of defects in this release plus those in the post release phase</P><P></P><P>check the pivot table and it's going to be easy to understand</P><P>what I want to achieve is almost done but how can I make for the fix_period 3 to have the value 70 on the first row not the second</P><P>result is correct whenever value of the pre-release period is greater than that of the post release</P><P>please do not hesitate to ask any question</P></BODY></HTML> Wed, 18 Jun 2014 20:10:40 GMT https://community.qlik.com/t5/QlikView/help-with-custom-cummulation-in-pivot-table/m-p/705883#M254470 ali_hijazi 2014-06-18T20:10:40Z Re: help with custom cummulation in pivot table https://community.qlik.com/t5/QlikView/help-with-custom-cummulation-in-pivot-table/m-p/705884#M254471 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Thu, 19 Jun 2014 13:06:10 GMT https://community.qlik.com/t5/QlikView/help-with-custom-cummulation-in-pivot-table/m-p/705884#M254471 Gysbert_Wassenaar 2014-06-19T13:06:10Z Re: help with custom cummulation in pivot table https://community.qlik.com/t5/QlikView/help-with-custom-cummulation-in-pivot-table/m-p/705885#M254472 <HTML><HEAD></HEAD><BODY><P>thank you very much indeed</P></BODY></HTML> Thu, 19 Jun 2014 19:10:14 GMT https://community.qlik.com/t5/QlikView/help-with-custom-cummulation-in-pivot-table/m-p/705885#M254472 ali_hijazi 2014-06-19T19:10:14Z