Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
how can i count in the layout the number of customer that paid the minimum price in each company?
i added a sample data/
my culc is wrong in the sample.
thanks.
With a selection in company, you can make it work using
=Count({$<Customer={"=PRICE=min(TOTAL PRICE)"}>}Customer)
But I guess you want have this expression consider the dimensional value of company, potentially for all companies.
Without a change to the script, you can use
=Sum( Aggr( If(PRICE = Min(TOTAL<Company> PRICE), 1), Company, Customer))
With a selection in company, you can make it work using
=Count({$<Customer={"=PRICE=min(TOTAL PRICE)"}>}Customer)
But I guess you want have this expression consider the dimensional value of company, potentially for all companies.
Without a change to the script, you can use
=Sum( Aggr( If(PRICE = Min(TOTAL<Company> PRICE), 1), Company, Customer))
Please try this
Count (Distinct aggr(Min(Total PRICE),Customer))
Sum({$<PRICE={"$(=$(vMinPrice))"}>}Customer)
where variable
vMinPrice=Min(PRICE)