topic Re: Subtotal for dimensions in QlikView https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426577#M807565 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Refer to the attached sample using Valuelist method (synthetic dimension)</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180769_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Oct 2017 02:25:07 GMT devarasu07 2017-10-25T02:25:07Z Subtotal for dimensions https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426573#M807561 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I was wondering if I could get some help please.</P><P></P><P>I have a list of sales team members and their sales in a pivot table. I would like to show the subtotal for each sales team as well as the grand total. Please see example below of current data set and what I would like to achieve.</P><P></P><P>Current dataset</P><TABLE border="1" class="jiveBorder" height="64" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 267px; height: 36px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales Team</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Number of deals</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">Sales1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">23</TD></TR><TR><TD style="padding: 2px;">Sales2</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">40</TD></TR><TR><TD style="padding: 2px;">Sales3</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">25</TD></TR><TR><TD style="padding: 2px;"><STRONG>Total</STRONG></TD><TD style="padding: 2px;"><STRONG>12</STRONG></TD><TD style="padding: 2px;"><STRONG>88</STRONG></TD></TR></TBODY></TABLE><P></P><P></P><P><STRONG>Desired Result</STRONG></P><TABLE border="1" class="jiveBorder" height="68" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 236px; height: 70px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales Team</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Number od deals</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">Sales1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">23</TD></TR><TR><TD style="padding: 2px;">Sales2</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">40</TD></TR><TR><TD style="padding: 2px;">Sales3</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">25</TD></TR><TR><TD style="padding: 2px;"><STRONG>Total</STRONG></TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">88</TD></TR><TR><TD style="padding: 2px;"><STRONG>Blue team</STRONG></TD><TD style="padding: 2px;"><STRONG>9</STRONG></TD><TD style="padding: 2px;"><STRONG>63</STRONG></TD></TR><TR><TD style="padding: 2px;"><STRONG>Red team</STRONG></TD><TD style="padding: 2px;"><STRONG>3</STRONG></TD><TD style="padding: 2px;"><P><STRONG>25</STRONG></P></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Many thanks,</P><P></P><P>Esther</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426573#M807561 Anonymous 2020-11-25T16:16:04Z Re: Subtotal for dimensions https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426574#M807562 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please try Pivot table where should be selected option "show partial sum" per each dimension on the presentation tab.</P><P>Hope it will help you.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Max</P></BODY></HTML> Tue, 24 Oct 2017 22:09:28 GMT https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426574#M807562 maxsheva 2017-10-24T22:09:28Z Re: Subtotal for dimensions https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426575#M807563 <HTML><HEAD></HEAD><BODY><P>Hi Max,</P><P></P><P>It worked, thank you so much for your quick response.</P><P></P><P>Have a great evening!</P><P></P><P>Best,</P><P></P><P>Esther</P></BODY></HTML> Tue, 24 Oct 2017 22:32:32 GMT https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426575#M807563 Anonymous 2017-10-24T22:32:32Z Re: Subtotal for dimensions https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426576#M807564 <HTML><HEAD></HEAD><BODY><P>You may want to read <A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Tue, 24 Oct 2017 22:59:34 GMT https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426576#M807564 Peter_Cammaert 2017-10-24T22:59:34Z Re: Subtotal for dimensions https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426577#M807565 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Refer to the attached sample using Valuelist method (synthetic dimension)</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180769_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Oct 2017 02:25:07 GMT https://community.qlik.com/t5/QlikView/Subtotal-for-dimensions/m-p/1426577#M807565 devarasu07 2017-10-25T02:25:07Z