How to get max value using aggr function

[rajaqliks]

Hi experts,

how to get max values on each date of each product and sum of each date values

the result should be like this

Answer:

 

Question :

[Lisa_P · Accepted solution]

Use this expression for Sales measure:
Sum(Aggr(Max(Sales), Product, Date))