topic Question about aggregation in va 7.4 in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Question-about-aggregation-in-va-7-4/m-p/596493#M13203 <P>Hi All,</P><P>&nbsp;</P><P>I have a question regarding aggregation in VA 7.4. I'm currently trying to get the MAX value, based on the SUM (see image below for an example).</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sum example.PNG" style="width: 291px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33151i6143ED81A8F68612/image-size/large?v=v2&amp;px=999" role="button" title="sum example.PNG" alt="sum example.PNG" /></span></P><P>&nbsp;</P><P>Preparing this in EG is not an option, because some values are calculated dynamically in VA, which result in different SUM values and therefore different MAX values. As such, I was wondering if anyone knows if there is a possible way to do this in VA?</P><P>&nbsp;</P><P>Best,</P><P>&nbsp;</P><P>Jian</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 15 Oct 2019 12:17:46 GMT JianShen 2019-10-15T12:17:46Z Question about aggregation in va 7.4 https://communities.sas.com/t5/SAS-Visual-Analytics/Question-about-aggregation-in-va-7-4/m-p/596493#M13203 <P>Hi All,</P><P>&nbsp;</P><P>I have a question regarding aggregation in VA 7.4. I'm currently trying to get the MAX value, based on the SUM (see image below for an example).</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sum example.PNG" style="width: 291px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/33151i6143ED81A8F68612/image-size/large?v=v2&amp;px=999" role="button" title="sum example.PNG" alt="sum example.PNG" /></span></P><P>&nbsp;</P><P>Preparing this in EG is not an option, because some values are calculated dynamically in VA, which result in different SUM values and therefore different MAX values. As such, I was wondering if anyone knows if there is a possible way to do this in VA?</P><P>&nbsp;</P><P>Best,</P><P>&nbsp;</P><P>Jian</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 15 Oct 2019 12:17:46 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Question-about-aggregation-in-va-7-4/m-p/596493#M13203 JianShen 2019-10-15T12:17:46Z