Calculating Percentages

[Alta88]

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

[Alta88]

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

[Alta88]

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. 

[Greg_Deckler]

@Alta88 Can you elaborate? Each row has a different Sheller so I don't understand.