I'm not sure if I got your file structure correct.
Would be grateful for you to modify the xlsx attached
in the Forum thread to more closely match yours.
Of what type is your datasource?
Also attached is an example workbook the employs
pivoting, pulling out a dimension, and Level of Detail
calculations to obtain the Gantt.