max value

[#1]

Dear friends,

i have the following senario,

that is

year    month   amount

2008   jan            500

2008    feb           1000

2009    mar           600

2009     apr           1500

2012     sep            2200

2012     oct              3000

2012     nov             4000

2012      dec             5000

so i need each year what month have a max value dynamicallty i need to know

how

[jagan]

Hi,

Please find attached file for solution, use FirstSortedValue() for this.

Use Year as dimension and =FirstSortedValue(month, -amount) as expression.

Regards,

Jagan.

[#3]

Thanks for having Reply,

but my requirement is different

that mens in bar chart i want to show current year which month has max value and same way prev year which month has max value

u got my req

[#4]

hi

try this in your script.

a:

LOAD   year,

     max(amount)

FROM

C:\Users\vishwaranjan\Desktop\test_4.xlsx

(ooxml, embedded labels, table is Sheet1) Group by year ;

[#5]

Hi,

Check out the attached one..

hope it helps u..