I am looking for an Excel expert to design a dynamic spreadsheet to track my Club Promoters Performance. It should be dynamic to the number of promoters and future dates I want to add. It should have a color pie graph indicating how much of the total guests the promoter have brought - sorted by day, week, month, year, and overall.
Promoter Name -
Day of Promotion - Fridays, Saturdays
Number of Guests -
Profitability - Number of Guests / Total Number of Guests