topic Re: Need help with subtotal in pivot in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442784#M165036 <HTML><HEAD></HEAD><BODY><P>On the Presentation tab of the properties screen check Partial Sums for the dimensions that you want to see subtitels for. If you change the dimensions in the chart to a drilldown group don't forget to enable the Partial Sums for the group. If you remove a dimension from the chart then the Partial Sums option for that dimension is removed too. It doesn't automagically reappear if you later add that dimension again.</P></BODY></HTML> Mon, 17 Dec 2012 14:57:54 GMT Gysbert_Wassenaar 2012-12-17T14:57:54Z Need help with subtotal in pivot https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442781#M165033 <HTML><HEAD></HEAD><BODY><P>I've created a what if analysis and ve put subotal on top from proerties settings. I'm getting the subtoal for all fields when im changing the slider value. But when i further drill down in pivot i'm only getting the sum of the field selected. </P><P></P><P>I want even if i drill down in pivot i shud get the subotal. Hope someone can help me with this....</P></BODY></HTML> Mon, 17 Dec 2012 14:24:23 GMT https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442781#M165033 2012-12-17T14:24:23Z Re: Need help with subtotal in pivot https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442782#M165034 <HTML><HEAD></HEAD><BODY><P>can u post ur file ?</P></BODY></HTML> Mon, 17 Dec 2012 14:37:48 GMT https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442782#M165034 2012-12-17T14:37:48Z Re: Need help with subtotal in pivot https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442783#M165035 <HTML><HEAD></HEAD><BODY><P>attached sample file</P></BODY></HTML> Mon, 17 Dec 2012 14:52:51 GMT https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442783#M165035 2012-12-17T14:52:51Z Re: Need help with subtotal in pivot https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442784#M165036 <HTML><HEAD></HEAD><BODY><P>On the Presentation tab of the properties screen check Partial Sums for the dimensions that you want to see subtitels for. If you change the dimensions in the chart to a drilldown group don't forget to enable the Partial Sums for the group. If you remove a dimension from the chart then the Partial Sums option for that dimension is removed too. It doesn't automagically reappear if you later add that dimension again.</P></BODY></HTML> Mon, 17 Dec 2012 14:57:54 GMT https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442784#M165036 Gysbert_Wassenaar 2012-12-17T14:57:54Z Re: Need help with subtotal in pivot https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442785#M165037 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert, i've tried wat u ve suggested it is still showing the same result.&nbsp; I'm getting the subtotal but when i select select any 1 field and change the slider value it shows me the sume of the selected field only.....</P></BODY></HTML> Mon, 17 Dec 2012 17:41:03 GMT https://community.qlik.com/t5/QlikView/Need-help-with-subtotal-in-pivot/m-p/442785#M165037 2012-12-17T17:41:03Z