I have a table like below with charge for each item with the effective date so that from that day on wards the charge listed will be the charge of the item.
I would like to calculate the charge of an item year over year as of the 12/31 of that year.
if there is no effective date for a given year then there is no change in the charge from the last effective date.
the table looks like
and the desired results like
Any help is greatly appreciated.