SOLVED

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)
Solution

@Excel 

See the attached version.

Sir, why we leave space in Week 1?

@Excel 

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