Good Morning, I have a problem and I have really been struggling on getting what I want so here I come.
Please find below the data that I have from SalesForce. 3 Columns: Main Consultant | Date | Record Count (Please find print scree below: PICTURE1).
I would like that in a GRID (not a table) the 3 best consultant appears as in Picture 2.
I would need 6 formulas, but I try out everything I could find online (Slice, Sort, Rank, etc...) and I can't figure it out.
So 2 little questions:
Is it possible?
How to go about it.?
Thank you in advance!!! :)