now i have another situation .
Head,
[Sub-Head] as subhead,
//System,
//Equipment,
//QTY,
[Total Time(min)]as TOtaltime_MECH,
[PM Duration Time (min)],
If(Match(subhead,'MECHANICAL'),'Mechanical',table1) as NewField,
[Breakdown Time (min)] as BRK_MECH,
//Others,
[Response Time (min)],
[Serviceability (%)] as service1,
[Availability (%)]as avail1 ,
//Remarks,
//N
from
table1;
concantanate
Head,
[Sub-Head] as subhead,
//System,
//Equipment,
//QTY,
[Total Time(min)]as TOtaltime_MECH,
[PM Duration Time (min)],
If(Match(subhead,'MECHANICAL'),'Mechanical',table1) as NewField,
[Breakdown Time (min)] as BRK_MECH,
//Others,
[Response Time (min)],
[Serviceability (%)] as service1,
[Availability (%)]as avail1 ,
//Remarks,
//N
from
table2;
concatenate
Head,
[Sub-Head] as subhead,
//System,
//Equipment,
//QTY,
[Total Time(min)]as TOtaltime_MECH,
[PM Duration Time (min)],
If(Match(subhead,'MECHANICAL'),'Mechanical',table1) as NewField,
[Breakdown Time (min)] as BRK_MECH,
//Others,
[Response Time (min)],
[Serviceability (%)] as service1,
[Availability (%)]as avail1 ,
//Remarks,
//N
from
table3;
now i have three similar type of table containing data of diff depatment . i want to plot graph on the dimension of subhead that contain the value of department like electical , mech ,T1 respectively and i want to rename it and just want t1 as value.
