I have a dataset in the below format: Year_month Peril Average BC 201501 BI 130 201502 PD 150 201503 AD 170 I want to create a report such that when i plot this months in excel on X axis, i get an option to set one month as base and rest figures should be divided by that base figure. I want an option to change the base month like first it should 201501, then 201502 , I have attached a sample data to make it more clear. request yoy to provide the reponse asap.
... View more