How to display the biggest of the numbers

[#1]

If I have 3 numbers

ID Num

1     10

1      60

3      90.

Here for ID 1 i only want to display 60 which is the largest among 10 and 60.How do I do that ?

Thank you.

[sunny_talwar]

May be like this in straight table:

Dimension: ID

Expression: Max(Num)

[#3]

Can  I do the same for the date,can I select the latest date among 2 dates ?

[sunny_talwar]

Sure you can, I think the only thing would be that Max(Date) would be an integer, if you want to see the date format, change it to Date(Max(Date))

[#5]

I Have max(sum(num)) ,but it still showing all 3

[sunny_talwar]

Not sure I understand.

You cannot double Aggregate without using Aggregation function. You need something similar to this: Max(Aggr(Sum(num), SomeDimension))

[#7]

DATE(MAX([Expiration Date],AB1Key))

Can I do something like this? My ABKey has multiple exp dates,so I only want to display the ABKey with the latest exp date .

[Anonymous]

Try this

Date( RangeMax( Max([ExpirationDate]) , Max(AB1Key)))

This take the Max from the two fields.

[#9]

Thank you Edagr,but this gives an error which says error in calculated dimension.

[#10]

=Date(Max([Lease Expiration Date]) , (AB1Key))

I am using the above in my dimension along with other dimensions in the straight table,but the above dimension is giving error saying error in calculated dimension.

sunindia‌