FirstSortedValue()

[chrisbrown1]

I have the following table:

I want to create another table that will only have the circled row.

I have Customer for my dimension. My minimum unit price by customer is: =Aggr(Min(UnitPrice), Customer)  which gives me:

How do I add the Product and UnitSales to this table and how do I get the FirstSortedValue so that I only get the Customer, Product, UnitSales and UnitPrice for that one row?

[dplr-rn]

Why dont you sent a limit on the dimension to show bottom 1 value

[pradosh_thakur]

Try the below

I have wriiten the expression such that it will fetch the row that has lowest unitprice

min({<Customer={"=min(UnitPrice)=min( TOTAL  aggr( min(UnitPrice),Customer))"}>}UnitPrice)

The expression could be simpler i guess.

[vishsaggi · Accepted solution]

Did you try like in your expression

=Firstsortedvalue(Product, Aggr(Min(UnitPrice), Customer)
=Firstsortedvalue(UnitSales, Aggr(Min(UnitPrice), Customer)
=Firstsortedvalue(UnitPrice, Aggr(Min(UnitPrice), Customer)

[chrisbrown1]

Thank you Vishsaggi.