Trend based logic

[nareshthavidishetty]

Hi All,

i want to show trend line from 201704 to 201804 based on the retention logic i have included my excel file please let me know

my logic for deal mat is cdt=201803 and dealmat dt =201804 then sum of o/s Amt=

my logic for deal cr    is cdt=201804  and creation dat =201804 then sum of o/s Amt=

retention = deal Cr/Deal Mat for this i want to implement trend