Question related percentage difference

Super Contributor

Hello Everyone,

How to calculate percentage difference for each week for each salesperson. what I mean is that I wanna know what is the progress of each sales person week wise?


Please help..??


Here is a attached file.

4 Replies
best response confirmed by allyreckerman (Microsoft)


See the attached version.

Sir, why we leave space in Week 1?


Because we cannot calculate a percentage for the first week - there is no week before it to compare with.

understood sir.
Thank you so much sir