topic How to calculate dimension wise Sub Total in a Pivot Table in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189150#M52131 <HTML><HEAD></HEAD><BODY><P>Hi Rikab,</P><P>Thanks for your response...</P><P>Yes I have tried that before ... but it doesn't give the result needed..... It will display as follows</P><P></P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1854.screen.bmp"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/1854.screen.bmp" /></A></P><P>(See attached test application)</P><P>I want to display sub total values for all the three Sales Reps...</P><P></P><P>Thanks in advance ,</P><P></P><P>Nilupa</P></BODY></HTML> Mon, 06 Sep 2010 11:00:07 GMT 2010-09-06T11:00:07Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189146#M52127 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want to display dimension wise sub total in a pivot chart.. For an example ;Sales Rep wise Sales... See the attached screenshot.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2304_sourceID:2304" /></P><P>Please help me on this issue.......</P><P></P><P>Thanks and Regards,</P><P>Nilupa</P></BODY></HTML> Mon, 06 Sep 2010 05:42:53 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189146#M52127 2010-09-06T05:42:53Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189147#M52128 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Go to <STRONG>Presentation Tab</STRONG> and look for <STRONG>Dimension and Expression</STRONG> (Top Left Corner). Select the Dimension and check <STRONG>Show Partial Sum</STRONG>.</P><P>Hope this will work .</P><P>- Manish</P><P></P></BODY></HTML> Mon, 06 Sep 2010 07:14:36 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189147#M52128 manishkumar75 2010-09-06T07:14:36Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189148#M52129 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P>Thanks for your response.. I have tried that.. but it doesn't give the result what I want... I need to display Sub Totals like follows;</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7711.SCREENSHOT.bmp"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/7711.SCREENSHOT.bmp" /></A></P><P>Any idea???</P><P></P><P>Tanks and Regards,</P><P>Nilupa</P></BODY></HTML> Mon, 06 Sep 2010 08:46:47 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189148#M52129 2010-09-06T08:46:47Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189149#M52130 <HTML><HEAD></HEAD><BODY><P>Try something like that as shown in the below screen shot:</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/2425.help.JPG"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/2425.help.JPG" /></A></P><P>Try and let me know the solution</P></BODY></HTML> Mon, 06 Sep 2010 10:00:09 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189149#M52130 2010-09-06T10:00:09Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189150#M52131 <HTML><HEAD></HEAD><BODY><P>Hi Rikab,</P><P>Thanks for your response...</P><P>Yes I have tried that before ... but it doesn't give the result needed..... It will display as follows</P><P></P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1854.screen.bmp"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/1854.screen.bmp" /></A></P><P>(See attached test application)</P><P>I want to display sub total values for all the three Sales Reps...</P><P></P><P>Thanks in advance ,</P><P></P><P>Nilupa</P></BODY></HTML> Mon, 06 Sep 2010 11:00:07 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189150#M52131 2010-09-06T11:00:07Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189151#M52132 <HTML><HEAD></HEAD><BODY><P>Hi nilupaboralessa,</P><P>If you want to show total of Sales Rep. Maybe you can check Partial Sum of InvDate (or other dimension that follow Sales Rep)</P><P>Hope this help</P><P>Tatar</P></BODY></HTML> Mon, 06 Sep 2010 11:09:40 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189151#M52132 2010-09-06T11:09:40Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189152#M52133 <HTML><HEAD></HEAD><BODY><P>Hi Tatar,</P><P>Thanks a lot... U solved my problem...:)</P><P>Regards,</P><P>Nilupa</P></BODY></HTML> Mon, 06 Sep 2010 11:15:50 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189152#M52133 2010-09-06T11:15:50Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189153#M52134 <HTML><HEAD></HEAD><BODY><P>I have done the required changes in your document. Please look in to it!</P></BODY></HTML> Mon, 06 Sep 2010 11:30:35 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189153#M52134 2010-09-06T11:30:35Z How to calculate dimension wise Sub Total in a Pivot Table https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189154#M52135 <HTML><HEAD></HEAD><BODY><P>Thanks Rikab <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 06 Sep 2010 11:38:28 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-dimension-wise-Sub-Total-in-a-Pivot-Table/m-p/189154#M52135 2010-09-06T11:38:28Z