How to get min value in text

[#1]

In the following QVW when i select model  as 600 and vertical as Electric i want to show the minimum amount coming in straight table  into text box along with the customer whose amount is minimum.

Please refer the sheet 1 in the QVW

[MayilVahanan]

Hi,

     Try like this:

     =min(aggr(sum(Amount),Customer)) & '  Customer Name: '&if(GetSelectedCount(Vertical)>0, Concat(distinct Customer,','))

     or

     =min(aggr(sum(Amount),Customer)) & '  Customer Name: '&Concat(distinct Customer,',')

[#3]

I want the customer name who has min amount ie vipin

[CELAMBARASAN · Accepted solution]

Try this

=FirstSortedValue(Customer, Aggr(Sum(Amount),Customer,Model,Vertical))

[MayilVahanan]

Hi

     =min(aggr(sum(Amount),Customer)) & '  Customer Name:'& FirstSortedValue(Customer,Amount)

     Hope it helps