Getting Percentages based on Sum


So I have a board categorized into groups of our sales team members. They each have project names and a total $$ amount in the rows below.

What I’m trying to do is get a percentage of what each sales member has sold out of the overall total amount. (Example: Bob sold $3,000. Everyone together sold $17,000 so his percentage is 17.6%)

Monday sums columns at the end of each group and will give me a grand total at the very bottom, but I can’t figure out where to go from there.

Any help is greatly appreciated! Thank you!

Hi @danielle0127 - This is something better suited to a Dashboard than a formula column calculation. A pie chart could display this data as a fraction of the whole by salesperson, region, etc.

That might be my only option I think. Thank you for the response!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.