topic Re: sum in pivot table in QlikView https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805921#M1041193 <HTML><HEAD></HEAD><BODY><P>I have attached,</P><P>Here If I choose single month at a time, I got correct result,</P><P>But If I choose jan and feb both than % distribute between two months.. so on..</P><P></P><P></P><P>Thanks for help</P></BODY></HTML> Wed, 10 Dec 2014 13:05:35 GMT tyagishaila 2014-12-10T13:05:35Z sum in pivot table https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805917#M1041189 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" height="138" style="width: 658px; height: 88px;"><TBODY><TR style="height: 15.0pt;"><TD class="xl84" height="40" style="height: 30.0pt; width: 163pt;" width="217"><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73121_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></TD><TD class="xl85" colspan="3" style="border-left: none; width: 186pt;" width="248"></TD><TD class="xl85" colspan="3" style="border-left: none; width: 174pt;" width="231"></TD></TR></TBODY></TABLE><P>I want this type of pivot table in qlik view</P><P>here year wise F and M sum is total 100% but when I did it I got correct result if I show on 1 year info as I select more then 1 yr then total % divided into two years.</P><P>i.e. YTD 11-12 and YTD 12-13 total % sum is 100% irrespect to each YTD.</P></BODY></HTML> Wed, 10 Dec 2014 12:08:23 GMT https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805917#M1041189 tyagishaila 2014-12-10T12:08:23Z Re: sum in pivot table https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805918#M1041190 <HTML><HEAD></HEAD><BODY><P>can you provide data source</P></BODY></HTML> Wed, 10 Dec 2014 12:29:14 GMT https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805918#M1041190 arulsettu 2014-12-10T12:29:14Z Re: sum in pivot table https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805919#M1041191 <HTML><HEAD></HEAD><BODY><P>I have posted it ,But I dont know where,</P><P>Could I drop mail of it,</P><P>here how I attach file</P></BODY></HTML> Wed, 10 Dec 2014 12:49:45 GMT https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805919#M1041191 tyagishaila 2014-12-10T12:49:45Z Re: sum in pivot table https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805920#M1041192 <HTML><HEAD></HEAD><BODY><P>click reply and then click use advanced editor then attach the files </P></BODY></HTML> Wed, 10 Dec 2014 12:52:20 GMT https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805920#M1041192 arulsettu 2014-12-10T12:52:20Z Re: sum in pivot table https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805921#M1041193 <HTML><HEAD></HEAD><BODY><P>I have attached,</P><P>Here If I choose single month at a time, I got correct result,</P><P>But If I choose jan and feb both than % distribute between two months.. so on..</P><P></P><P></P><P>Thanks for help</P></BODY></HTML> Wed, 10 Dec 2014 13:05:35 GMT https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805921#M1041193 tyagishaila 2014-12-10T13:05:35Z Re: sum in pivot table https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805922#M1041194 <HTML><HEAD></HEAD><BODY><P>do you have data source in excel</P></BODY></HTML> Wed, 10 Dec 2014 13:14:16 GMT https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805922#M1041194 arulsettu 2014-12-10T13:14:16Z Re: sum in pivot table https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805923#M1041195 <HTML><HEAD></HEAD><BODY><P>no, it is in sql</P></BODY></HTML> Wed, 10 Dec 2014 16:52:22 GMT https://community.qlik.com/t5/QlikView/sum-in-pivot-table/m-p/805923#M1041195 tyagishaila 2014-12-10T16:52:22Z