https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567708#M742771 <P>Attached QVW&nbsp;</P> Wed, 10 Apr 2019 14:20:21 GMT shekhar_analyti 2019-04-10T14:20:21Z https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567707#M742770 <P>Hi All ,</P><P>I am not sure about&nbsp;How to manipulate Total Value in Pivot Table using using show partial sum ?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PIV.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9890i3AEB724A6C8DD140/image-size/large?v=v2&amp;px=999" role="button" title="PIV.png" alt="PIV.png" /></span></P><P>DATA&nbsp;</P><P>LOAD * INLINE [<BR />ITEM, SWITCH<BR />A, 1<BR />B, 0<BR />A, 1<BR />D, 0<BR />A, 1<BR />B, 0<BR />A, 1<BR />D, 1<BR />A, 1<BR />B, 1<BR />A, 1<BR />D, 0<BR />A, 0<BR />A, 1<BR />B, 0<BR />C, 0<BR />D, 0<BR />A, 0<BR />B, 1<BR />A, 1<BR />A, 0<BR />A, 1<BR />B, 0<BR />B, 0<BR />C, 1<BR />Q, 0<BR />B, 1<BR />D, 0<BR />R, 0<BR />E, 1<BR />A, 1<BR />B, 0<BR />C, 1<BR />D, 0<BR />A, 0<BR />B, 0<BR />A, 1<BR />C, 0<BR />Q, 1<BR />A, 1<BR />B, 1<BR />R, 1<BR />R, 0<BR />Z, 0<BR />B, 0<BR />C, 1<BR />D, 0<BR />A, 0<BR />B, 0<BR />A, 0<BR />C, 1<BR />Q, 1<BR />A, 0<BR />B, 0<BR />R, 1<BR />R, 0<BR />Z, 1<BR />B, 1<BR />C, 0<BR />D, 0<BR />A, 0<BR />B, 0<BR />A, 1<BR />C, 0<BR />Q, 0<BR />A, 0<BR />B, 0<BR />R, 0<BR />R, 0<BR />Z, 1<BR />B, 1<BR />C, 0<BR />D, 1<BR />A, 1<BR />B, 1<BR />A, 0<BR />C, 0<BR />Q, 0<BR />A, 0<BR />B, 1<BR />R, 1<BR />R, 1<BR />Z, 0<BR />B, 0<BR />C, 0<BR />D, 1<BR />A, 1<BR />B, 0<BR />A, 0<BR />C, 0<BR />Q, 0<BR />A, 0<BR />B, 1<BR />R, 0<BR />R, 1<BR />Z, 1<BR />B, 1<BR />C, 1<BR />D, 0<BR />A, 1<BR />B, 1<BR />A, 1<BR />C, 0<BR />Q, 0<BR />A, 1<BR />B, 1<BR />R, 1<BR />];</P><P><BR />LOAD * INLINE [<BR />ITEM, GROUP<BR />A, T1<BR />B, T1<BR />C, T2<BR />D, T4<BR />Q, T6<BR />R, T6<BR />E, T7<BR />Z, T6<BR />];</P><P>Thanks &amp; Regards</P><P>Shekar</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567707#M742770 shekhar_analyti 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567708#M742771 <P>Attached QVW&nbsp;</P> Wed, 10 Apr 2019 14:20:21 GMT https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567708#M742771 shekhar_analyti 2019-04-10T14:20:21Z https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567715#M742772 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P><P>Please help .</P> Wed, 10 Apr 2019 14:26:38 GMT https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567715#M742772 shekhar_analyti 2019-04-10T14:26:38Z https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567729#M742773 <P>May be this</P><PRE>If(Dimensionality() = 1, Count(DISTINCT ITEM)/Count({&lt;SWITCH={1}&gt;}SWITCH), Count({&lt;SWITCH={1}&gt;}SWITCH))</PRE> Wed, 10 Apr 2019 14:38:27 GMT https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567729#M742773 sunny_talwar 2019-04-10T14:38:27Z https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567782#M742774 <P>Thank You Sunny Bhai .&nbsp;</P><P>&nbsp;</P><P>Is there any way for Labels .. like TOTAL FOR T1 , TOTAL FOR T2&nbsp; etc ......&nbsp;</P> Wed, 10 Apr 2019 16:27:33 GMT https://community.qlik.com/t5/QlikView/How-to-manipulate-Total-Value-in-Pivot-Table-using-using-show/m-p/1567782#M742774 shekhar_analyti 2019-04-10T16:27:33Z