Hi, I can understand you might have problems grasping DI if you use Excel as a reference. DI Studio is used for standardised ETL, where the target are detail data layers, data marts and similar.   But your requirement doesn't look like a generic table structure, feels like a report to me. Or what is the application? Sorry, I can't the logic/use of the caclulated column. Please elaborate about the data flow and use. Perhaps this is better suited for a report tool, like a stored process.   If you need to perform this in DI, my gut feeling is that you need some kind of user written code. ... View more