Is any one have idea that how to calculate this in aggregation function.
This is not working in my Calculation and return nothing.
Where you are using this expression, in chart? Can you provide some sample data, it is difficult to understand without data.
If you nest aggregation functions like sum and max you need to use the aggr function:
Replace Dim1,Dim2,...,DimN with the dimensions of your chart,
Retrieving data ...