topic Help with Partial Sums in QlikView https://community.qlik.com/t5/QlikView/Help-with-Partial-Sums/m-p/570779#M212683 <HTML><HEAD></HEAD><BODY><P>Hello everybody <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I make in QlikView pivot chart like on imege below, where Total column is calculated dimension because I need to group value from media column. I also check partial sums check box for Total column. Problem that I have is that <STRONG>TOTAL 4 </STRONG>need to sum value that belong to his group and total from <STRONG>TOTAL 1,TOTAL 2, </STRONG><STRONG style="font-size: 10pt; line-height: 1.5em;">TOTAL 3</STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">, and </SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">TOTAL 5 </STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">need to sum value that belong to his group and total from </SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">TOTAL 4. </STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">Is it necessary to create two more Calculated Dimension or is there an easier way. </SPAN></P><P></P><P>I also dont know why he don't count total where is more than one value in month column, in <STRONG>Mar</STRONG> column for <STRONG>TOTAL 4 </STRONG> i have value 1650 and 2000 and he didn't show Total for them. He only show total for column with one value. (Image below)</P><P><IMG alt="4.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54918_4.png" style="width: 620px; height: 480px;" /></P><P></P><P>I hope you will help me to solve the problem. Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 13 Mar 2014 11:35:59 GMT 2014-03-13T11:35:59Z Help with Partial Sums https://community.qlik.com/t5/QlikView/Help-with-Partial-Sums/m-p/570779#M212683 <HTML><HEAD></HEAD><BODY><P>Hello everybody <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I make in QlikView pivot chart like on imege below, where Total column is calculated dimension because I need to group value from media column. I also check partial sums check box for Total column. Problem that I have is that <STRONG>TOTAL 4 </STRONG>need to sum value that belong to his group and total from <STRONG>TOTAL 1,TOTAL 2, </STRONG><STRONG style="font-size: 10pt; line-height: 1.5em;">TOTAL 3</STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">, and </SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">TOTAL 5 </STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">need to sum value that belong to his group and total from </SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">TOTAL 4. </STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">Is it necessary to create two more Calculated Dimension or is there an easier way. </SPAN></P><P></P><P>I also dont know why he don't count total where is more than one value in month column, in <STRONG>Mar</STRONG> column for <STRONG>TOTAL 4 </STRONG> i have value 1650 and 2000 and he didn't show Total for them. He only show total for column with one value. (Image below)</P><P><IMG alt="4.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54918_4.png" style="width: 620px; height: 480px;" /></P><P></P><P>I hope you will help me to solve the problem. Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 13 Mar 2014 11:35:59 GMT https://community.qlik.com/t5/QlikView/Help-with-Partial-Sums/m-p/570779#M212683 2014-03-13T11:35:59Z