https://community.qlik.com/t5/App-Development/Pivot-Dynamic-Dimension-Sum-with-highest-Value/m-p/2550287#M110354 <P>Hey <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6139">@ManuelRühl</a>,</P><P>&nbsp;</P><P>I got it using two Aggr functions:</P><DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class="">&nbsp;</DIV></DIV><PRE>Aggr(Max(Aggr(Sum(Expression1), Dim1, Dim2)), Dim1)</PRE><P>&nbsp;</P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="alexquimu_0-1780128984678.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/188638i4299B33380D9D036/image-size/large?v=v2&amp;px=999" role="button" title="alexquimu_0-1780128984678.png" alt="alexquimu_0-1780128984678.png" /></span><P><BR />Kind regards</P></DIV></DIV></DIV> Sat, 30 May 2026 08:17:35 GMT alejandroquinones 2026-05-30T08:17:35Z https://community.qlik.com/t5/App-Development/Pivot-Dynamic-Dimension-Sum-with-highest-Value/m-p/2550285#M110353 <P>Hi, I need this pivot table (example generated by test script):</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ManuelRhl_0-1780126492629.png" style="width: 811px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/188637i6462C9D5D2E0DFDA/image-dimensions/811x98?v=v2" width="811" height="98" role="button" title="ManuelRhl_0-1780126492629.png" alt="ManuelRhl_0-1780126492629.png" /></span></P><P>The highest sum(Expression1) per Dim1 must be presented in the pivot table like that.</P><P>I tried nearly everything Max,Aggr,Firstsortedvalue etc ...</P><P>Any suggestions?</P><P>Thanks in advance!</P> Sat, 30 May 2026 07:38:38 GMT https://community.qlik.com/t5/App-Development/Pivot-Dynamic-Dimension-Sum-with-highest-Value/m-p/2550285#M110353 ManuelRühl 2026-05-30T07:38:38Z https://community.qlik.com/t5/App-Development/Pivot-Dynamic-Dimension-Sum-with-highest-Value/m-p/2550287#M110354 <P>Hey <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6139">@ManuelRühl</a>,</P><P>&nbsp;</P><P>I got it using two Aggr functions:</P><DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class="">&nbsp;</DIV></DIV><PRE>Aggr(Max(Aggr(Sum(Expression1), Dim1, Dim2)), Dim1)</PRE><P>&nbsp;</P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="alexquimu_0-1780128984678.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/188638i4299B33380D9D036/image-size/large?v=v2&amp;px=999" role="button" title="alexquimu_0-1780128984678.png" alt="alexquimu_0-1780128984678.png" /></span><P><BR />Kind regards</P></DIV></DIV></DIV> Sat, 30 May 2026 08:17:35 GMT https://community.qlik.com/t5/App-Development/Pivot-Dynamic-Dimension-Sum-with-highest-Value/m-p/2550287#M110354 alejandroquinones 2026-05-30T08:17:35Z https://community.qlik.com/t5/App-Development/Pivot-Dynamic-Dimension-Sum-with-highest-Value/m-p/2550289#M110355 <P>Same answer as&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/291737">@alejandroquinones</a>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Lech_Miszkiewicz_0-1780130440563.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/188639i0CF6653884B497ED/image-size/large?v=v2&amp;px=999" role="button" title="Lech_Miszkiewicz_0-1780130440563.png" alt="Lech_Miszkiewicz_0-1780130440563.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 30 May 2026 08:41:12 GMT https://community.qlik.com/t5/App-Development/Pivot-Dynamic-Dimension-Sum-with-highest-Value/m-p/2550289#M110355 Lech_Miszkiewicz 2026-05-30T08:41:12Z