https://community.qlik.com/t5/QlikView/QlikView-PivotTable/m-p/1892053#M1217340 <P>Within the expressions it's not possible. But you calculate it as a synthetic dimension with something like:</P> <P>aggr(sum(Value), Dim1, Dim2)</P> <P>whereby Dim1 and Dim2 are the placeholder for the dimensional context.</P> <P>- Marcus</P> Fri, 11 Feb 2022 16:21:57 GMT marcus_sommer 2022-02-11T16:21:57Z https://community.qlik.com/t5/QlikView/QlikView-PivotTable/m-p/1891818#M1217320 <P class="paragraph-371">Hello everyone,</P> <P class="paragraph-371">I hope you are doing excellent <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P class="paragraph-371">&nbsp;</P> <P class="paragraph-371">I have a question:</P> <P class="paragraph-371">In my delivery, the business would like to have a PivotTable(Right Side of the attachment), currently we have implemented the PivotTable(Left Side of the attachment).</P> <P class="paragraph-371">Is there any possibility to merge the rows of the column <STRONG><SPAN class="text-308">Metric1</SPAN> </STRONG>so that it is related to the <SPAN class="text-308"><STRONG>COMMODITY</STRONG> </SPAN>column, but the <SPAN class="text-308"><STRONG>Metric2</STRONG> </SPAN>should be as it is - related to the <SPAN class="text-308"><STRONG>REASON</STRONG> <STRONG>NAME</STRONG> </SPAN>column? I know that is it possible in Excel, but could not find if/how it is possible in QlikView.</P> <P class="paragraph-371">Thank you very much for your time and understanding,</P> <P class="paragraph-371">Wish you a cool day/weekend!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="VadimCosman1_0-1644564098998.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72085i3F5CABD24848CB68/image-size/medium?v=v2&amp;px=400" role="button" title="VadimCosman1_0-1644564098998.png" alt="VadimCosman1_0-1644564098998.png" /></span></P> <P>&nbsp;</P> Fri, 11 Feb 2022 07:22:39 GMT https://community.qlik.com/t5/QlikView/QlikView-PivotTable/m-p/1891818#M1217320 VadimCosman1 2022-02-11T07:22:39Z https://community.qlik.com/t5/QlikView/QlikView-PivotTable/m-p/1892053#M1217340 <P>Within the expressions it's not possible. But you calculate it as a synthetic dimension with something like:</P> <P>aggr(sum(Value), Dim1, Dim2)</P> <P>whereby Dim1 and Dim2 are the placeholder for the dimensional context.</P> <P>- Marcus</P> Fri, 11 Feb 2022 16:21:57 GMT https://community.qlik.com/t5/QlikView/QlikView-PivotTable/m-p/1892053#M1217340 marcus_sommer 2022-02-11T16:21:57Z