The exact answer is fairly dependent on how your data is organized, would it be possible to post a packaged workbook with some sample data?
Thank you for replying. Iam attaching the sample data for one product. I tried to do this by creating 2 calculated fields (Renew and renewal rate) as you will see in the workbook. After creating them, when i try to move the renewal rate into "Rows" , it aggregates it by default. Wondering if there is any other better way to achieve this.