Sum of the sorted values

[RishabhTFC]

Hi all

I am facing a problem.

I use firstsortedvalue function to get the prices of latest date of  products. Now I want to make a KPI that shows the sum of that sorted values of all the products.

thanks

[vishsaggi]

May be this?

= FirstsortedValue(Price, -Aggr(Sum(Price), Date, Product))

[rubenmarin]

Hi Shubham, aggr() can do the operation for each product, enclose it in a Sum() and you have the sum of the different products:

Sum(Aggr(YourExpression, ProductFieldName))