Pivot Table for Scouting
I have been working on a huge pivot table and have hit a part that I am at a loss of complete. It is for my scout troop and shows all scouts with ages, ranks, merit badges, etc.
In the Row Label I have Program, Age, Birth Date, Scout, and Rank. Current the results show all the ranks, but here is the part I can't figure out, how do I show just the last rank earned. The data base has the dates.