To Calculate Day over Day change for each

[Anonymous]

Hi,

I need to calculate day over day chnages for each account and for each manger. I need to calculate the percentage chnage on daily basis and the entries are getting created from monday to friday. 

1. Need to get the distinct count of Number column as there can be duplicate entries

2. Need to get the chnage % for both managers and the number.

Kindly help me with it, Thank you.

I have attached a sample data