topic Summarization of a higher dimension in a Pivot Table with calculated dimensions and without using AGGR in QlikView https://community.qlik.com/t5/QlikView/Summarization-of-a-higher-dimension-in-a-Pivot-Table-with/m-p/885522#M308753 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hello experts! </SPAN></P><P><SPAN lang="en" style="color: #000000;"><BR /></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en">I have a simple question...</SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN style="color: #000000;">In a Pivot Table I have Dimensions and Calculated Dimensions:</SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><IMG alt="22-06-2015 05-47-01 p- m-.png" class="jive-image image-1" src="/legacyfs/online/90449_22-06-2015 05-47-01 p- m-.png" style="height: 138px; width: 620px;" /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN style="color: #000000;">Yellow: Dimensions.</SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en">White: Calculated Dimensions.</SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en">Green: Expression.</SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><SPAN lang="en">The calculated dimension <SPAN lang="en">is the sum of the previous dimension:</SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="text-decoration: underline;">DC GRUPO SUB CANAL</SPAN>:<BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #000000;">AGGR(SUM(Units), CANAL, GRUPO SUB CANAL)</SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #575757;"><STRONG><BR /></STRONG></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #575757;"><STRONG><BR /></STRONG></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #575757;"><SPAN lang="en"><STRONG>I need an expression that makes the sum of Units of</STRONG><SPAN lang="en"><STRONG> previous dimension, in this case </STRONG><SPAN lang="en"><STRONG>the sum of Units grouped by GRUPO SUB CANAL. </STRONG></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN><STRONG style="color: #000000; font-size: 10pt; line-height: 1.5em;"><SPAN lang="en">It is possible to make a expression of previous dimension in a Pivot Table with dimensions calculated <SPAN style="text-decoration: underline;">without using AGGR</SPAN>? <SPAN lang="en">Something like that: <STRONG style="color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">SUM(TOTAL&lt;Dimensións, Calculated Dimensions&gt;Units</STRONG><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">) </SPAN></SPAN></SPAN></STRONG></P><P><STRONG style="color: #000000; font-size: 10pt; line-height: 1.5em;"><SPAN lang="en"><SPAN style="color: #222222; font-size: 12.8000001907349px; font-family: arial, sans-serif;"><BR /></SPAN></SPAN></STRONG></P><P><SPAN lang="en"><SPAN style="color: #222222; font-size: 12.8000001907349px; font-family: arial, sans-serif;">Thanks a lot!!!</SPAN></SPAN></P><P><SPAN lang="en">Regards,</SPAN></P><P>Juan Pablo Rodrigues.</P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #000000;"><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><STRONG><BR /></STRONG></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 23 Jun 2015 18:26:10 GMT 2015-06-23T18:26:10Z Summarization of a higher dimension in a Pivot Table with calculated dimensions and without using AGGR https://community.qlik.com/t5/QlikView/Summarization-of-a-higher-dimension-in-a-Pivot-Table-with/m-p/885522#M308753 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hello experts! </SPAN></P><P><SPAN lang="en" style="color: #000000;"><BR /></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en">I have a simple question...</SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN style="color: #000000;">In a Pivot Table I have Dimensions and Calculated Dimensions:</SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><IMG alt="22-06-2015 05-47-01 p- m-.png" class="jive-image image-1" src="/legacyfs/online/90449_22-06-2015 05-47-01 p- m-.png" style="height: 138px; width: 620px;" /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN style="color: #000000;">Yellow: Dimensions.</SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en">White: Calculated Dimensions.</SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en">Green: Expression.</SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><SPAN lang="en">The calculated dimension <SPAN lang="en">is the sum of the previous dimension:</SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en" style="color: #000000;"><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="text-decoration: underline;">DC GRUPO SUB CANAL</SPAN>:<BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #000000;">AGGR(SUM(Units), CANAL, GRUPO SUB CANAL)</SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #575757;"><STRONG><BR /></STRONG></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #575757;"><STRONG><BR /></STRONG></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #575757;"><SPAN lang="en"><STRONG>I need an expression that makes the sum of Units of</STRONG><SPAN lang="en"><STRONG> previous dimension, in this case </STRONG><SPAN lang="en"><STRONG>the sum of Units grouped by GRUPO SUB CANAL. </STRONG></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN><STRONG style="color: #000000; font-size: 10pt; line-height: 1.5em;"><SPAN lang="en">It is possible to make a expression of previous dimension in a Pivot Table with dimensions calculated <SPAN style="text-decoration: underline;">without using AGGR</SPAN>? <SPAN lang="en">Something like that: <STRONG style="color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">SUM(TOTAL&lt;Dimensións, Calculated Dimensions&gt;Units</STRONG><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.8000001907349px;">) </SPAN></SPAN></SPAN></STRONG></P><P><STRONG style="color: #000000; font-size: 10pt; line-height: 1.5em;"><SPAN lang="en"><SPAN style="color: #222222; font-size: 12.8000001907349px; font-family: arial, sans-serif;"><BR /></SPAN></SPAN></STRONG></P><P><SPAN lang="en"><SPAN style="color: #222222; font-size: 12.8000001907349px; font-family: arial, sans-serif;">Thanks a lot!!!</SPAN></SPAN></P><P><SPAN lang="en">Regards,</SPAN></P><P>Juan Pablo Rodrigues.</P><P><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><SPAN style="color: #000000;"><SPAN lang="en"><SPAN lang="en"><SPAN lang="en"><STRONG><BR /></STRONG></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 23 Jun 2015 18:26:10 GMT https://community.qlik.com/t5/QlikView/Summarization-of-a-higher-dimension-in-a-Pivot-Table-with/m-p/885522#M308753 2015-06-23T18:26:10Z