Dynamically Rank Table By Different Groups

Hello,   I have data that shows sales by team (L3), then rolls that up to sales under a bigger team (L2) which rolls up to the team at L1.  Year Employee Team L1 Team L2 Team L3 Sales 2...