topic sum of pivot table in QlikView https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418887#M428337 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hello, Is it possible to display only the total in a tcd? </SPAN></P><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en">For example, we develop the other dimensions but the expressions is calculate o</SPAN><SPAN lang="en">nly on the total line?</SPAN></P><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en"> thank you in advance</SPAN></P></BODY></HTML> Mon, 09 Oct 2017 14:33:49 GMT pirotfab 2017-10-09T14:33:49Z sum of pivot table https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418887#M428337 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hello, Is it possible to display only the total in a tcd? </SPAN></P><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en">For example, we develop the other dimensions but the expressions is calculate o</SPAN><SPAN lang="en">nly on the total line?</SPAN></P><P><SPAN lang="en"></SPAN></P><P><SPAN lang="en"> thank you in advance</SPAN></P></BODY></HTML> Mon, 09 Oct 2017 14:33:49 GMT https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418887#M428337 pirotfab 2017-10-09T14:33:49Z Re: sum of pivot table https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418888#M428338 <HTML><HEAD></HEAD><BODY><P>Can you share sample data and expected output?</P></BODY></HTML> Mon, 09 Oct 2017 14:46:17 GMT https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418888#M428338 krishnacbe 2017-10-09T14:46:17Z Re: sum of pivot table https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418889#M428339 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179052_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Mon, 09 Oct 2017 15:12:12 GMT https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418889#M428339 pirotfab 2017-10-09T15:12:12Z Re: sum of pivot table https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418890#M428340 <HTML><HEAD></HEAD><BODY><P>What is the Expression you used for TRS?</P></BODY></HTML> Mon, 09 Oct 2017 15:17:14 GMT https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418890#M428340 krishnacbe 2017-10-09T15:17:14Z Re: sum of pivot table https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418891#M428341 <HTML><HEAD></HEAD><BODY><P>Hope the attached file will help you.&nbsp; Replace the expression you have used for TRS in below expression.</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">f</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Dimensionality</SPAN><SPAN style="font-size: 8pt;">()=1, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Quantity</SPAN><SPAN style="font-size: 8pt;">)/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Quantity</SPAN><SPAN style="font-size: 8pt;">),'') </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG alt="sample.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179047_sample.PNG" style="height: auto;" /></SPAN></P></BODY></HTML> Mon, 09 Oct 2017 15:24:40 GMT https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418891#M428341 krishnacbe 2017-10-09T15:24:40Z Re: sum of pivot table https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418892#M428342 <HTML><HEAD></HEAD><BODY><P>it's ok, thank you very much</P></BODY></HTML> Tue, 10 Oct 2017 06:49:07 GMT https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418892#M428342 pirotfab 2017-10-10T06:49:07Z Re: sum of pivot table https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418893#M428343 <HTML><HEAD></HEAD><BODY><P>If the Solution worked for you, close the thread by marking the correct answer.</P></BODY></HTML> Tue, 10 Oct 2017 12:50:54 GMT https://community.qlik.com/t5/QlikView/sum-of-pivot-table/m-p/1418893#M428343 krishnacbe 2017-10-10T12:50:54Z