How to create following view for purchase price comparision

[vikasmahajan]

Dear all,

Rate analysis for 5-6 years and how is vendor providing low/high  purchase rates

Material Name	Rate 2011	Rate 2012	Rate 2013
PARACETAMOL   (GAL) ANQUILUAN  B.P.	45.58	58.45	68.50

Vikas

[kaushiknsolanki]

Hi,

     Create a chart with dimension as Material_Name

     and 3 expression one for each yr.

     Max({<Year = {"2011"}>}Rate)

     Max({<Year = {"2012"}>}Rate)

     Max({<Year = {"2013"}>}Rate)

Regards,

Kaushik Solanki

[vikasmahajan]

Thanks ,

Kaushik sir

Is there possibility to have dynamic years in expression instead of hard coding it .

Bye

Vikas

[kaushiknsolanki · Accepted solution]

Hi,

     Yes why not.

     You can use something like this.

          Max({<Year = {"$(=year(today())) "}>}Rate)

          Max({<Year = {"$(=year(today()))-1 "}>}Rate)

          Max({<Year = {"$(=year(today()))-2 "}>}Rate)

Regards,

Kaushik Solanki

[vikasmahajan]

Thanks Sir,

Also I require Comprehensive Analysis study materials , Please share if you have it.

Vikas

[kaushiknsolanki]

Hi Vikas,

As of now I dont have but sure if i get any, i will sure share with you.

Regards,

Kaushik Solanki