HELP!!!!!!!!!!!!!!!!!!

This is the final solution, you can obviously generalize it but it works ...

SET

ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;-€ #.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';

SET DayNames='lun;mar;mer;gio;ven;sab;dom';



levels_tmp:

load * Inline

[

Desigination, level

Engineer,1

Asst Manager, 2

Manager, 3

];



MainTable:

NoConcatenate

load * Inline

[Person Name ,Division ,Desigination ,Change date

Person A,IT,Engineer,1/1/2013

Person B,IT,Engineer,1/1/2013

Person A,IT,Manager,2/2/2013

Person B,IT,Asst Manager,3/3/2013

Person B,IT,Manager,1/2/2013

];



Left Join



levels:

load * Inline

[

Desigination, level

Engineer,1

Asst Manager, 2

Manager, 3

];



MT:

NoConcatenate

LOAD * Resident MainTable;



FOR i = 1 to 3

//     LOAD * Resident MainTable;

Left Join

LOAD level,Desigination as des_descr$(i) Resident levels_tmp where level=$(i);

NEXT



DROP Table MainTable;

DROP Table levels_tmp;



All:

NoConcatenate

LOAD

Division, [Person Name], MaxString(des_descr1) as des_descr1,  MaxString(des_descr2) as des_descr2, MaxString(des_descr3) as des_descr3

Resident MT

Group by Division, [Person Name];



DROP Table MT;

THE TABLE CHART DIMENSIONS ARE:

Division

Person Name

des_descr1

des_descr2

des_descr3

Use 1 as Expression (you can even hide the column