Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a table in which a field Type which conatains two type of value X and y and in another column there is many numeric values but i want only latest and minimum values.
table is like
XandY, VALUE
X,12754
X,12721
X,12719
Y,4073
Y,4072
Y,3907
I want the X minimum value X-12719 and Y-3907
Please help
Thanks
SEE IF IT IS WAHT YOU NEED
Hi,
Use the TOTAL qualifier within the expressions
Min(TOTAL <XandY> VALUE)
Hope that helps.
Miguel
You can try this expression.
Min({<XandY = {"X"}>}VALUE)
Only change X to Y for getting minimum value of Y.
Regards,
Kaushik Solanki
Thanks Both but i want two min values let me explain the table first it is some thing like
XandY, E, S, E-S
X, 123192, 110438, 12754
X, 123192, 110471, 12721
X, 123192, 110473, 12719
Y, 33167, 29094, 4073
Y, 33167, 29095, 4072
Y, 33167, 29260, 3907
In a straight table or pivot table it is look like this
i want to highlight or otherwise take the minimum values of XandY in the text box to show the minimum values like
X-12719
Y-3907
how this could be done please help.
Thanks
Hi
Please check the attached file..
Hope that helps
PROVE WITH THIS
=min(TOTAL <XandY>RangeMin())
REGARDS