7 Replies Latest reply: Jan 21, 2013 6:47 AM by Jörg Hildebrandt

# find highest value

Hi all

Seems my head is not the best today.

I am trying to find the highest value in a table. In this case it is the value in month 10.

 ID Month Value Item 01 7.279.389 Item 02 7.621.106 Item 03 7.928.659 Item 04 8.374.085 Item 05 7.582.951 Item 06 8.461.163 Item 07 8.800.933 Item 08 8.578.971 Item 09 8.505.260 Item 10 9.313.773 Item 11 9.109.731 Item 12 8.673.098

The desired result should look like this:

 ID Month Value Item 10 9.313.773

I tried with max, but failed.

Can somebody give me an idea for a formula ?

Joerg

• ###### Re: find highest value

Hi,

Take Dimension as ID and expression as =firstsortedvalue ( Value, -Month)

Otherwise go like this Take Dim as ID, Month and expression as =Sum({<Month={\$(=Max(Month))}>}Value)

Cheers!!

Jagan

• ###### Re: find highest value

Dear Jagan.

Thanks. I will try when I am back in office.

Cheers.

Joerg

• ###### Re: find highest value

Dear Jagan

I think rank function will better fit my needs.

Thank you for helping.

Cheers

Joerg

• ###### Re: find highest value

Hi Joerg,

Can I suggest you try FirstSortedValue() function.

Let me know if it works

Regards

• ###### Re: find highest value

hii

see attached file

• ###### Re: find highest value

Hi

Thanks a lot. This helps me.

• ###### Re: find highest value

hi

try it

only(id),

max(value) as maxvalue,

FirstSortedValue(mon,-value) as monthno.;