Hi All,
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).
![sum example.PNG sum example.PNG](https://communities.sas.com/t5/image/serverpage/image-id/33151i6143ED81A8F68612/image-size/large?v=v2&px=999)
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?
Best,
Jian