Set ANalysis !!

[nikhilgarg]

HEy,

In my excel sheet , i have 3 columns :  Year , Customer , Sales.

I want to show Customer name for last year.

I have used following set analysis but it is giving error. Kindly tell em what to do.

Customer = p({<Year={$(max(Year)}-1>})

Thanks

[nikhilgarg]

See the attached file

[nikhilgarg]

See the attached file

[nikhilgarg]

See the attached

[sundarakumar]

Hi,

PFA. This should help..

I have done it in my own example..

-Sundar

[#6]

HI,

Result of your attached file,

PFA