Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two fields in data Id and sales. I am trying to take sum of sales for maximum value of ID but it is giving me sum only for 1 maximum id value which is at the last. the expression I am using is as below:
Sum({$<id={"$(=max(id))"}>}sales)
May be you need this
FirstSortedValue(Aggr(Sum(Sales), id), -id)
Hi,
method 1:
=FirstSortedValue(ID,-Sales)
method 2:
=max(aggr(sum(Sales),ID))
Also try this May be?
= Max(Aggr(Sum(Sales), Id))
Max(aggr(sum(sales),ID))
Please check the screenshots.
Let me know.
Thanks.