topic Re: Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum in QlikView https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564032#M508271 <P>The attached file is having security constraint as it has section access could you please share a version without section access</P> Tue, 02 Apr 2019 14:28:03 GMT anushree1 2019-04-02T14:28:03Z Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1563929#M508270 <P>I have Pivot Table with 3 Dimensions and 2 Expressions - a number and a percentage. I'm using Partial Sum to get the Total at the bottom (in green), but I only want the number total. How can I remove / hide the percentage total?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="partialsum.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9274i93CB22432739B651/image-size/medium?v=v2&amp;px=400" role="button" title="partialsum.PNG" alt="partialsum.PNG" /></span></P><P>Thanks for any help!</P><P>&nbsp;</P> Sat, 16 Nov 2024 03:58:50 GMT https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1563929#M508270 bo1980 2024-11-16T03:58:50Z Re: Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564032#M508271 <P>The attached file is having security constraint as it has section access could you please share a version without section access</P> Tue, 02 Apr 2019 14:28:03 GMT https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564032#M508271 anushree1 2019-04-02T14:28:03Z Re: Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564065#M508272 I've updated the attached qvw Tue, 02 Apr 2019 15:15:00 GMT https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564065#M508272 bo1980 2019-04-02T15:15:00Z Re: Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564523#M508273 <P>Please check if the attached works</P> Wed, 03 Apr 2019 12:03:00 GMT https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564523#M508273 anushree1 2019-04-03T12:03:00Z Re: Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564525#M508274 <P>Although its got rid of the data, I want the row to be removed completely for %</P> Wed, 03 Apr 2019 12:09:17 GMT https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564525#M508274 bo1980 2019-04-03T12:09:17Z Re: Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564537#M508275 <P>Partial sums are grouped at the Dimension Level so a place holder will get created for each expression.</P><P>So I dont think it could be removed&nbsp;</P> Wed, 03 Apr 2019 12:24:23 GMT https://community.qlik.com/t5/QlikView/Only-one-Total-required-in-Pivot-Table-Expression-with-multiple/m-p/1564537#M508275 anushree1 2019-04-03T12:24:23Z