Skip to Content
0
Former Member
May 31, 2009 at 06:11 AM

maximum value for a key figure

832 Views

Hi ,

I have a requirement as below:

Year Demand

01/2009 300

02/2009 800

03/2009 500

04/2009 900

05/2009 400

I need show a column which indicates the max demand value among the 5 months.

like for this example the max value is 900.

I tried the data function MAX but the MAX function is for only 2 values and not for than 2 values.

Thanks In Advance.