Dear all,
Please refer to the attached file. I have a set of data that consists of loans issued in 2016, and I have calculated the weighed average life of the loans, based on the life of the loans (years) and loan amounts ($) So far very simple - the weighted average life in 2016 = 5.923 years, as I show in the first tab.
However, I also want to see how was the evolution of the YTD weighed average per quarter (tab 2). For example, in Q2 I would consider Q1+Q2 data to calculate the weighted average. In Q3 I would consider Q1+Q2+Q3 data to calculate the weighted average, and so on. I certainly can achieve that by filtering the date every time, but I would like to see the evolution in a single graph. The graph should have the following points:
Q1 YTD- 3.667
Q2 YTD- 5.714
Q3 YTD- 5.222
Q4 YTD- 5.923
I have not found a way to do this. I would appreciate your help, and please let me know if something is not clear.
Thanks in advance.
Best,
David
