expressions as timeline

[#1]

Hi guys,

Unfortunately the data im using is derived from a excel pivot like data, example:

Product               Year 1 total          Year 2 total     Year 3 total

A                      

B

B

I would need to make a timeline chart out of the above, so that the Years would be on the x-axis. Can anyone help..Automatically the years are presented in the y-axis.

Thanks.

[SunilChauhan · Accepted solution]

tab1:

cross table(columns,value,1)

load

Product  ,            

Year 1 total       ,   Year 2 total    , Year 3 total

from path.

Load *,

left(columns,4) as Year

resident tab1;

drop table path1;