Salesperson Biggest Sales for Month Rankings

[Lankanzero]

Hi Everyone,

I've been trying to figure out this problem for a few days and I'm stumped.

As per the attached image, I have a set of data that describes the sales that each salesperson has made, when it occurred and for how much.

My problem is getting it this data to be populated in the format I have. The selected Sales Person and Month and the biggest sales they made in that month

Any help would be great!

 

[Fluff]

Cross posted Salesperson Biggest Sales for Month Rankings

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Lankanzero]

Hi Everyone,

I've been trying to figure out this problem for a few days and I'm stumped.

As per the attached image, I have a set of data that describes the sales that each salesperson has made, when it occurred and for how much.

My problem is getting it this data to be populated in the format I have. The selected Sales Person and Month and the biggest sales they made in that month View attachment 11855View attachment 11854

Any help would be great!

Hi Apologies, here is the link for the post in the other forum: Salesperson Biggest Sales for Month Rankings