First minimum value

[qvqfqlik]

I need help with calculating first minimum Unit price for an Offer number within Same Division

eg below: In division 07, need to see any one of the Offer numbers with Minimum Unit Price

[sunny_talwar]

There is 4 minimum Unit Price for Division 07... which OfferNo you want to see and where do you want to see this information?

[qvqfqlik]

in the same chart I need the display the data

within a division, I need to display any one of record the Offer number that is having same minimum Unit price

for eg: for division 07 , any one of those offer numbers with minimum price, now that all offers in that division have same price, I need  to display on of those instead all the four offers numbers

This should happen for all the divisions.

[sunny_talwar · Accepted solution]

Instead of using OfferNo as a dimension, try an expression like this:

Dimension

ITEMNO

DIVISION

UNIT_PRICE

Expression

If(UNIT_PRICE = Min(TOTAL <ITEMNO, DIVISION> UNIT_PRICE), MinString(OFFERNO))