Perform historical analysis using main data and change log.

Hello All,   how can I do perform historical analysis based on Initial State and Change Log data.           to get a table like this.   Should I create a new table or conn...