Find the Max value of a field and then its corresponding values using an expression

[#1]

Hi everybody,

I have a table as follows:

ID	Name	Order
5	A	4
5	B	2
5	C	1
5	D	5
5	E	3
4	A	2
4	B	4
4	C	1
4	D	3
3	A	1
3	B	4
3	C	3
3	D	2
2	A	5
2	B	4
2	C	3
2	D	2
2	E	1

For the maximum ID (that is 5) i want to display all the 'Name' with their respective 'Order' value. I want the end result to be as follows:

ID	Name	Order
5	A	4
5	B	2
5	C	1
5	D	5
5	E	3

Thanks for your inputs!!!!   

[tresesco]

Straight table:

Dimension: ID

Exp1: FirstSortedValue(Name, -Order)

Exp2: Max(Order)

[jyothish8807]

Hi,

In Dimension; Use calculated Dimension

max(ID)

Exp1: Name

Exp2: Order

Hope it helps

Regards

KC

[#4]

Hi,

please find the attachment,

Dimensoin= use this

if(ID=max(ID),ID)

and use a second dimension too

if(ID=max(ID),Name)

and in expression

Order

with Regards

Harshita Gaur

[anbu1984]

Check this

Dimension: ID,Name

Expression: If(ID=Max(TOTAL ID), Order)