is this the chart you expected
first I converted your year into a real date (it is a number)
next the running total formula is
then the percent of total no the total running
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Genderjd.twbx 24.5 KB
Just to clarify, I want to show the total employees by gender % for ever year.