https://community.qlik.com/t5/QlikView/Aggr-dimension/m-p/1817437#M1213118 <P>May be try this</P><LI-CODE lang="markup">FirstSortedValue(Aggr(Sum(LastSale), Symbol, Rilevamento), -Aggr(Rilevamento, Symbol, Rilevamento))</LI-CODE> Wed, 23 Jun 2021 16:06:25 GMT sunny_talwar 2021-06-23T16:06:25Z https://community.qlik.com/t5/QlikView/Aggr-dimension/m-p/1817435#M1213117 <P>Hi there,</P><P>here my problem...</P><P>From the Raw Data Table I want to catch the row in red border (for each Symbol/Sequence is the value of LastSale for the higher value of Count)</P><P>If I build a new aggregate table using an Aggr() as dimension,&nbsp; the Sum(LastSale) seems don't take into account the Aggr() dimension. Instead the value is exactly the sum of all rows.</P><P>What's wrong?</P><P>Thanks a lot in advance</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ciampaciampa_0-1624463301059.png" style="width: 468px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57441iBEFC3C78F2104760/image-dimensions/468x240?v=v2" width="468" height="240" role="button" title="ciampaciampa_0-1624463301059.png" alt="ciampaciampa_0-1624463301059.png" /></span></P><P>&nbsp;</P> Wed, 23 Jun 2021 16:01:28 GMT https://community.qlik.com/t5/QlikView/Aggr-dimension/m-p/1817435#M1213117 ciampaciampa 2021-06-23T16:01:28Z https://community.qlik.com/t5/QlikView/Aggr-dimension/m-p/1817437#M1213118 <P>May be try this</P><LI-CODE lang="markup">FirstSortedValue(Aggr(Sum(LastSale), Symbol, Rilevamento), -Aggr(Rilevamento, Symbol, Rilevamento))</LI-CODE> Wed, 23 Jun 2021 16:06:25 GMT https://community.qlik.com/t5/QlikView/Aggr-dimension/m-p/1817437#M1213118 sunny_talwar 2021-06-23T16:06:25Z https://community.qlik.com/t5/QlikView/Aggr-dimension/m-p/1819180#M1213298 <P>It works!</P><P>Thanks Sunny.</P> Thu, 01 Jul 2021 16:13:38 GMT https://community.qlik.com/t5/QlikView/Aggr-dimension/m-p/1819180#M1213298 ciampaciampa 2021-07-01T16:13:38Z