Hi Thomas, This could be an idea as well, however tables store data ONLY for the months, where the value exists. So for example, if the is no value in NOV, there is no record for this month as well. So we may have situation, where lag ( one month) will find previous record, but not necessary previous month. ( for DEC it…

Hi again , One option is related to point C ), where we could use union all and then use evaluate function call LISTAGG and then substr text from the column. Month Attr listagg (ATTR) substr(LISTAGG) - after coma SEP - 2015 Plain PLAN, null DEC - 2015 Custom CUSTOM, Plain Plain Issue is that source is MS SQL server 2008…