Forum Discussion
Calculating Percentages
How would I calculate certain percentage from a pool of accounts built by those listed in the Sheller Name column? I need to find 30% of all accounts built by each Sheller.
| ID | Customer | Sheller Name |
| 543415062-7 | Emmeline Donohoe | Orton Bath |
| 400987061-3 | Emilee Fursland | Bran Kellock |
| 653736247-4 | Carr Witsey | Corby Divell |
| 192129752-2 | Odette Fretwell | Bobby Chezelle |
| 063991025-4 | Revkah Cowper | Sile Utterson |
| 782773078-7 | Ariel Pougher | Kay Atlay |
| 374877100-2 | Brett Pankhurst. | Merle Carrier |
| 202310552-8 | Leland Joska | Elsy Kubista |
| 324245031-0 | Tim Cesaric | Ronny Goneau |
| 173717721-8 | Stacee Laurent | Augy Levecque |
| 221825560-X | Nealson Bartens | Julieta Yeabsley |
| 794711564-8 | Sim Waud | Maxy Caroline |
| 901902319-5 | Nerissa Parkyn | Simon Filasov |
| 582439028-2 | Ray Hopfner | Jeanelle Gallaher |
| 384486936-0 | Mollie Belson | Mannie Searles |
| 222913305-5 | Damara Bernollet | Burty Burtwell |
| 353106582-3 | Audy Aikett | Bendicty Rucklidge |
| 169377787-8 | Tybalt Vile | Hephzibah McKague |
| 569901010-6 | Franni Farragher | Hannis Goch |
| 114073108-4 | Mayor Mackro | Lucienne Noddings |
| 069022747-7 | Kaleb Bussel | Ron Powner |
| 651628710-4 | Melisse Dominico | Cacilia Sides |
| 531516137-4 | Laura McKeag | Erminie Sabate |
| 906573284-5 | Alec Fardy | Annabella Preddle |
| 185950027-7 | Doris Le Conte | Alair Huller |
| 668655443-X | Lennard Lucia | Hadria Chipps |
| 040271753-8 | Nahum MacClay | Cosmo Oret |
| 667869341-8 | Piper Badsey | Jamie Symmers |
| 597349723-2 | Jemimah Kolyagin | Suellen Brignall |
| 496152153-1 | Karen Worlidge | Ronica Jobin |
| 728378593-0 | Meade Fencott | Lauryn Wilshire |
| 333961507-1 | Ninetta Mecozzi | Gizela Hitzmann |
| 122178293-2 | Kennett Aspey | Avery Dryburgh |
| 146795654-6 | Elladine Tallman | Luca Matushevich |
| 402058169-X | Arni Loadman | Janene Mussalli |
| 897875874-6 | Thibaut Wilkennson | Sawyere Grigsby |
| 247985575-9 | Antonie Heald | Ryon Capaldo |
| 474020756-7 | Lonnie Skerrett | Lebbie Huddles |
| 742712159-7 | Jehanna Doel | Natka Rochford |
| 919660247-3 | Karlan Woodberry | Clarance Merwood |
| 244842078-5 | Angelique Lempel | Maryl Faughey |
| 114655162-2 | Mikkel Linden | Dougy Showers |
| 455578556-8 | Tamra Ridolfo | Maximilian Zecchinii |
| 593628623-1 | Andras Comino | Rowland Decreuze |
| 611730706-3 | Sonny Jimenez | Row Maier |
| 379648109-4 | Rhonda Bisley | Rutledge Foxten |
| 227536648-2 | Candice Scatcher | Reynard Heeks |
| 191731897-9 | Oralia Fynn | Raye Macconachy |
| 733045460-5 | Erin Buck | Robbert Kondrachenko |
| 559909234-8 | Kacy Luisetti | Rosco Osgar |
| 602617541-5 | Tito Adriano | Claudian Schurig |
| 357520559-0 | Madalena Bruckental | Chariot McNevin |
| 951361586-3 | Granny Oen | Dorelle Aksell |
| 790230441-7 | Jessie Josephi | Ethelin Dunphy |
| 710848692-X | Dene Lorans | Egbert Priddie |
| 122690471-8 | Nata Balsellie | Ingamar MacAiline |
| 007858436-1 | Aymer Graves | Paulette Barbey |
| 958592966-X | Sharline Strettle | Ursulina Bettridge |
| 942004680-X | Cecilla Lanfear | Hart Thyer |
| 152263912-8 | Charin McCheyne | Jenica Tufts |
| 232487685-X | Isidoro Hargitt | Cole Standrin |
| 983217050-8 | Lenna Gregon | Millie Shaughnessy |
| 603083852-0 | Hetti Alldred | Guillema Castilljo |
| 987950488-7 | Vinny Bains | Fields Vida |
| 550349190-4 | Cointon Perazzo | Skelly Nester |
| 089470477-X | Dean Cuthbert | Wainwright Duffitt |
| 984088668-1 | Heida Ivel | Minne Bonifacio |
| 075817753-4 | Rodrick Clinch | Hubey Scorah |
| 070656503-7 | Randi Moultrie | Otto Danhel |
| 510205087-7 | Baillie Itzik | Skell Davids |
| 600378642-6 | Sharron Baldam | Erica Cornels |
| 167497944-4 | Kathe Bromidge | Torr Keyson |
| 135146654-2 | Dina Domerque | Angelika Wilmington |
| 138964887-7 | Gallard Robelow | Denyse Battyll |
| 776003194-7 | Chastity MacCourt | Maure Pifford |
| 947100871-9 | Rees Streat | Val McMenemy |
| 810470655-1 | Ardith Bjorkan | Sydney Norgate |
| 743611939-7 | Bernardine Shotton | Dela Kirsop |
| 069866053-6 | Muriel Carles | Rebeka Hampstead |
| 080754535-X | Jo-anne Baumler | Fairlie Torricella |
| 459224785-X | Penni Bines | Ned Itzakson |
| 983932270-2 | Ford Scamerden | Jemima Cobbing |
| 038264931-1 | Ernesta Bissill | Marcus Bengtson |
| 127173120-7 | Wally Putton | Olympe Vannoni |
| 160203691-8 | Redd McNicol | Gardie Yurmanovev |
| 531562055-7 | Gonzales Douthwaite | Maximilian Ventum |
| 816802469-9 | Wendye Doumer | Lainey Baitey |
| 807487447-8 | Lynnelle Himsworth | Correy Canedo |
| 334325879-2 | Essa Rearie | Karlotta Thrower |
| 001061751-5 | Yolanda Catanheira | Padraig Bottoms |
| 028759367-3 | Flossie Fenners | Ingrid Wooddisse |
| 466985141-1 | Halsy Vedeneev | Anatollo Darton |
| 671810265-2 | Isabella Hamblett | Guillermo Cabedo |
| 694288450-2 | Alana Flewett | Karlee Dessant |
| 398620489-X | Joaquin McGlone | Violante Blakeborough |
| 448489527-7 | Moyna Guyan | Corabel Isaksen |
| 702242762-3 | Glen Whardley | Torin Jiri |
| 382254367-5 | Anastasie Abramowitz | Conn Cumes |
| 137639003-5 | Gaby Ceyssen | Blake Shawcross |
| 908655008-8 | Yvette Yankishin | Ansell Forkan |
3 Replies
Alta88 Can you elaborate? Each row has a different Sheller so I don't understand.
Yes, sorry - the data I provided in the example is mock data so the Sheller names didn't repeat like I wanted them to. Essentially I need to find the total accounts worked by each Sheller and then calculate 30% of each of those totals.
Try this table:
Date ID Customer Sheller Name 11/28/2022 543415062-7 Emmeline Donohoe Talbot 11/28/2022 400987061-3 Emilee Fursland Talbot 11/28/2022 653736247-4 Carr Witsey Talbot 11/28/2022 192129752-2 Odette Fretwell Smith 11/28/2022 063991025-4 Revkah Cowper Smith 11/28/2022 782773078-7 Ariel Pougher Smith 11/28/2022 374877100-2 Brett Pankhurst. Talbot 11/28/2022 202310552-8 Leland Joska Smith 11/28/2022 324245031-0 Tim Cesaric Talbot 11/28/2022 173717721-8 Stacee Laurent Talbot 11/28/2022 221825560-X Nealson Bartens Smith 11/28/2022 794711564-8 Sim Waud Smith 11/28/2022 901902319-5 Eric Ballard Alley 11/28/2022 582439028-2 Ray Hopfner Alley 11/28/2022 384486936-0 Mollie Belson Talbot 11/28/2022 222913305-5 Damara Bernollet Smith 11/28/2022 353106582-3 Audy Aikett Talbot 11/28/2022 169377787-8 Tybalt Vile Alley 11/28/2022 569901010-6 Franni Farragher Smith 11/28/2022 114073108-4 Mayor Mackro Smith 11/28/2022 069022747-7 Kaleb Bussel Talbot 11/28/2022 651628710-4 Melisse Dominico Talbot 11/28/2022 531516137-4 Laura McKeag Smith 11/28/2022 906573284-5 Alec Fardy Talbot 11/28/2022 185950027-7 Doris Le Conte Alley 11/28/2022 668655443-X Lennard Lucia Talbot 11/28/2022 040271753-8 Nahum MacClay Alley 11/28/2022 667869341-8 Piper Badsey Talbot 11/28/2022 597349723-2 Jemimah Kolyagin Alley 11/28/2022 496152153-1 Karen Worlidge Alley 11/28/2022 728378593-0 Meade Fencott Talbot 11/28/2022 333961507-1 Ninetta Mecozzi Alley 11/28/2022 122178293-2 Kennett Aspey Alley 11/28/2022 146795654-6 Elladine Tallman Alley 11/28/2022 402058169-X Arni Loadman Alley 11/28/2022 897875874-6 Thibaut Wilkennson Talbot 11/28/2022 247985575-9 Antonie Heald Talbot 11/28/2022 474020756-7 Lonnie Skerrett Talbot 11/28/2022 742712159-7 Jehanna Doel Smith 11/28/2022 919660247-3 Karlan Woodberry Alley 11/28/2022 244842078-5 Angelique Lempel Smith 11/28/2022 114655162-2 Mikkel Linden Talbot 11/28/2022 455578556-8 Tamra Ridolfo Alley 11/28/2022 593628623-1 Andras Comino Smith 11/28/2022 611730706-3 Sonny Jimenez Smith 11/28/2022 379648109-4 Rhonda Bisley Smith 11/28/2022 227536648-2 Candice Scatcher Smith 11/28/2022 191731897-9 Oralia Fynn Talbot 11/28/2022 733045460-5 Erin Buck Talbot 11/28/2022 559909234-8 Kacy Luisetti Talbot 11/28/2022 602617541-5 Tito Adriano Talbot 11/28/2022 357520559-0 Madalena Bruckental Smith 11/28/2022 951361586-3 Granny Oen Talbot 11/28/2022 790230441-7 Jessie Josephi Smith 11/28/2022 710848692-X Dene Lorans Alley 11/28/2022 122690471-8 Nata Balsellie Alley 11/28/2022 007858436-1 Aymer Graves Talbot 11/28/2022 958592966-X Sharline Strettle Alley 11/28/2022 942004680-X Cecilla Lanfear Alley 11/28/2022 152263912-8 Charin McCheyne Alley 11/28/2022 232487685-X Isidoro Hargitt Talbot 11/28/2022 983217050-8 Lenna Gregon Alley 11/28/2022 603083852-0 Hetti Alldred Alley 11/28/2022 987950488-7 Vinny Bains Smith 11/28/2022 550349190-4 Cointon Perazzo Smith 11/28/2022 089470477-X Dean Cuthbert Smith 11/28/2022 984088668-1 Heida Ivel Alley 11/28/2022 075817753-4 Rodrick Clinch Talbot 11/28/2022 070656503-7 Randi Moultrie Talbot 11/28/2022 510205087-7 Baillie Itzik Alley 11/28/2022 600378642-6 Sharron Baldam Talbot 11/28/2022 167497944-4 Kathe Bromidge Smith 11/28/2022 135146654-2 Dina Domerque Smith 11/28/2022 138964887-7 Gallard Robelow Talbot 11/28/2022 776003194-7 Chastity MacCourt Smith 11/28/2022 947100871-9 Rees Streat Smith 11/28/2022 810470655-1 Ardith Bjorkan Alley 11/28/2022 743611939-7 Bernardine Shotton Talbot 11/28/2022 069866053-6 Muriel Carles Alley 11/28/2022 080754535-X Jo-anne Baumler Alley 11/28/2022 459224785-X Penni Bines Alley 11/28/2022 983932270-2 Ford Scamerden Talbot 11/28/2022 038264931-1 Ernesta Bissill Smith 11/28/2022 127173120-7 Wally Putton Smith 11/28/2022 160203691-8 Redd McNicol Smith 11/28/2022 531562055-7 Gonzales Douthwaite Smith 11/28/2022 816802469-9 Wendye Doumer Talbot 11/28/2022 807487447-8 Lynnelle Himsworth Talbot 11/28/2022 334325879-2 Essa Rearie Smith 11/28/2022 001061751-5 Yolanda Catanheira Smith 11/28/2022 028759367-3 Flossie Fenners Smith 11/28/2022 466985141-1 Halsy Vedeneev Smith 11/28/2022 671810265-2 Isabella Hamblett Talbot 11/28/2022 694288450-2 Alana Flewett Talbot 11/28/2022 398620489-X Joaquin McGlone Talbot 11/28/2022 448489527-7 Moyna Guyan Talbot 11/28/2022 702242762-3 Glen Whardley Smith 11/28/2022 382254367-5 Anastasie Abramowitz Alley 11/28/2022 137639003-5 Gaby Ceyssen Alley 11/28/2022 908655008-8 Yvette Yankishin Smith
