DataGrid: Aggregates

Aggregates

The DataGrid provider several built-in aggregates for column values. Supported aggregate functions are:
  • Sum Calculate total(sum) value of the collection.
  • Average Calculates the average of the numeric items in the collection.
  • Min Finds the smallest value in the collection.
  • Max Finds the largest value in the collection.
  • Count Counts the elements in a collection.
  • TrueCount Counts boolean elements with true value.
  • FalseCount Counts boolean elements with false value.

Aggregates

DataGrid will automatically generate necessary group cells based on the defined DataGridAggregate options.
#First NameLast NameEmailSalary
4CoraConnCora27@yahoo.com84 414,66 €
6JessieWilkinsonJessie_Wilkinson@gmail.com78 566,12 €
8MaryannHilpertMaryann.Hilpert12@gmail.com89 153,38 €
10AngelinaWardAngelina42@gmail.com73 625,86 €
11KaraBrekkeKara.Brekke@hotmail.com58 321,87 €
Total emails: 49236 370 194,35 €
<DataGrid TItem="Employee" Data="@employeeList" Responsive>
    <DataGridAggregates>
        <DataGridAggregate TItem="Employee" Field="@nameof( Employee.Email )" Aggregate="DataGridAggregateType.Count">
            <DisplayTemplate>
                @($"Total emails: {context.Value}")
            </DisplayTemplate>
        </DataGridAggregate>
        <DataGridAggregate TItem="Employee" Field="@nameof( Employee.Salary )" Aggregate="DataGridAggregateType.Sum" DisplayFormat="{0:C}" DisplayFormatProvider="@System.Globalization.CultureInfo.GetCultureInfo("fr-FR")" />
        <DataGridAggregate TItem="Employee" Field="@nameof( Employee.IsActive )" Aggregate="DataGridAggregateType.TrueCount" />
    </DataGridAggregates>
    <DataGridColumns>
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.Id)" Caption="#" Sortable="false" />
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.FirstName)" Caption="First Name" Editable="true" />
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.LastName)" Caption="Last Name" Editable="true" />
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.Email)" Caption="Email" Editable="true" />
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.Salary)" Caption="Salary" DisplayFormat="{0:C}" DisplayFormatProvider="@System.Globalization.CultureInfo.GetCultureInfo("fr-FR")" Editable="true">
            <EditTemplate>
                <NumericEdit TValue="decimal" Value="@((decimal)context.CellValue)" ValueChanged="@( v => context.CellValue = v)" />
            </EditTemplate>
        </DataGridColumn>
    </DataGridColumns>
</DataGrid>
@code {
    [Inject]
    public EmployeeData EmployeeData { get; set; }
    private List<Employee> employeeList;

    protected override async Task OnInitializedAsync()
    {
        employeeList = await EmployeeData.GetDataAsync();
        await base.OnInitializedAsync();
    }
}
By default all aggregate operations are run on in-memory Data. When working with large datasets that is not possible. So just as in the previous examples for large datasets you need to work with ReadData and set the AggregateData property.
#First NameLast NameEmailSalary
4CoraConnCora27@yahoo.com84 414,66 €
6JessieWilkinsonJessie_Wilkinson@gmail.com78 566,12 €
8MaryannHilpertMaryann.Hilpert12@gmail.com89 153,38 €
10AngelinaWardAngelina42@gmail.com73 625,86 €
11KaraBrekkeKara.Brekke@hotmail.com58 321,87 €
12YvetteFerryYvette22@gmail.com89 658,90 €
13PabloFriesenPablo_Friesen96@gmail.com77 090,27 €
14ErnestHomenickErnest_Homenick92@yahoo.com54 910,14 €
15LeslieWehnerLeslie_Wehner@hotmail.com78 930,58 €
16MiguelLynchMiguel.Lynch0@gmail.com65 348,06 €
17TommySwaniawskiTommy_Swaniawski@gmail.com92 326,27 €
18ViolaWildermanViola.Wilderman@yahoo.com76 575,00 €
19BrendaJacobsonBrenda_Jacobson55@gmail.com86 145,68 €
20RogerHerzogRoger_Herzog@gmail.com53 168,45 €
21CaseyWeberCasey90@yahoo.com56 257,49 €
22TaraSchoenTara_Schoen@yahoo.com72 637,29 €
23AlSanfordAl_Sanford1@yahoo.com88 870,12 €
24JillStokesJill.Stokes@yahoo.com59 252,89 €
25MarianArmstrongMarian_Armstrong@yahoo.com69 182,74 €
26JanieStantonJanie26@yahoo.com51 608,79 €
27DixieBlockDixie65@yahoo.com89 653,26 €
28TeresaDietrichTeresa.Dietrich@yahoo.com56 151,34 €
29ReneeHerzogRenee39@yahoo.com93 592,47 €
30DamonLubowitzDamon_Lubowitz@hotmail.com89 271,37 €
31CodyRauCody56@hotmail.com63 067,69 €
32EthelKassulkeEthel.Kassulke@yahoo.com92 175,30 €
33RudyWalshRudy_Walsh54@gmail.com76 356,17 €
34RossHauckRoss18@hotmail.com51 620,31 €
35OtisLittleOtis_Little28@hotmail.com77 906,94 €
36BenjaminFriesenBenjamin40@yahoo.com78 343,54 €
37MosesMosciskiMoses_Mosciski@gmail.com99 202,48 €
38KellieMurazikKellie_Murazik@gmail.com98 314,89 €
39NicholeKeeblerNichole69@gmail.com65 412,00 €
40BobbieRogahnBobbie.Rogahn7@yahoo.com52 889,16 €
41CharlieBorerCharlie.Borer68@hotmail.com50 448,59 €
42LuisRutherfordLuis.Rutherford@hotmail.com83 594,06 €
43JaredPfannerstillJared82@gmail.com54 282,76 €
44FloydSatterfieldFloyd96@yahoo.com59 157,17 €
45ClaudeParkerClaude_Parker55@gmail.com58 576,97 €
46DonaldDaughertyDonald.Daugherty@gmail.com66 692,86 €
47RolandBruenRoland5@yahoo.com98 404,23 €
48PaulineConroyPauline_Conroy@yahoo.com69 674,96 €
49LoraLockmanLora55@hotmail.com74 035,99 €
50JoeyKoelpinJoey_Koelpin@yahoo.com57 184,86 €
51StaceyGrahamStacey_Graham88@gmail.com88 562,39 €
52DaisyMedhurstDaisy75@yahoo.com51 011,13 €
53ErinCorwinErin_Corwin17@gmail.com70 013,81 €
54ArturoDenesikArturo.Denesik@gmail.com61 456,56 €
55CherylCollierCheryl.Collier@yahoo.com59 868,88 €
56AndresWilliamsonAndres34@yahoo.com74 180,71 €
57PhyllisWildermanPhyllis.Wilderman90@gmail.com59 518,29 €
58BillyWizaBilly84@gmail.com92 241,90 €
59WoodrowGibsonWoodrow_Gibson55@yahoo.com90 288,10 €
60CristinaHarrisCristina.Harris@yahoo.com81 762,53 €
61DarleneDanielDarlene.Daniel52@gmail.com74 142,55 €
62CourtneyFramiCourtney.Frami@yahoo.com68 435,70 €
63MaeFeeneyMae92@gmail.com65 623,26 €
64JoshDoyleJosh75@yahoo.com87 057,60 €
65GwenAbbottGwen.Abbott86@yahoo.com65 189,89 €
66MonaBeierMona8@gmail.com80 367,71 €
67MinnieCorwinMinnie_Corwin96@yahoo.com78 002,56 €
68DwightRunolfssonDwight99@gmail.com73 986,40 €
69BethBartellBeth.Bartell@yahoo.com85 841,65 €
70SteveSchulistSteve_Schulist@hotmail.com94 190,45 €
71PamGreenholtPam44@gmail.com75 695,28 €
72DarrelWilliamsonDarrel_Williamson@yahoo.com70 327,72 €
73RolandoSauerRolando_Sauer@hotmail.com84 971,22 €
74CesarSchaeferCesar79@yahoo.com92 704,04 €
75LuisLeannonLuis13@gmail.com61 167,01 €
76FannieWilliamsonFannie_Williamson@gmail.com94 194,50 €
77MariannePourosMarianne_Pouros60@hotmail.com71 394,54 €
78SpencerRogahnSpencer.Rogahn12@gmail.com55 993,84 €
79DonnieLuettgenDonnie_Luettgen@hotmail.com77 655,38 €
80BlancaBreitenbergBlanca77@hotmail.com75 633,97 €
81PatRohanPat_Rohan@gmail.com50 151,72 €
82VirginiaKassulkeVirginia_Kassulke@yahoo.com77 411,81 €
83LelaBreitenbergLela_Breitenberg44@hotmail.com53 894,64 €
84RandalKossRandal.Koss67@hotmail.com93 602,37 €
85KimberlyChristiansenKimberly_Christiansen2@hotmail.com65 089,52 €
86JeanBoyerJean42@hotmail.com99 805,01 €
87MurielShieldsMuriel.Shields12@gmail.com66 809,95 €
88MarcusEmmerichMarcus_Emmerich@yahoo.com99 401,27 €
89FaithNicolasFaith.Nicolas@yahoo.com50 439,25 €
90BoydDavisBoyd_Davis@gmail.com58 591,48 €
91WilburStiedemannWilbur29@gmail.com64 479,16 €
92RobertoStrackeRoberto_Stracke@yahoo.com57 007,18 €
93MindySmithamMindy.Smitham5@hotmail.com56 810,55 €
94DianneMaggioDianne.Maggio83@yahoo.com73 990,94 €
95MandyBahringerMandy55@hotmail.com69 018,94 €
96MarlonLednerMarlon.Ledner26@hotmail.com72 372,09 €
97LaverneSchusterLaverne.Schuster38@gmail.com84 767,07 €
98KendraCorkeryKendra_Corkery@gmail.com79 303,18 €
99ChrisBartonChris.Barton@yahoo.com68 642,57 €
100EdPriceEd.Price21@gmail.com84 665,20 €
101TraceyDurganTracey.Durgan3@hotmail.com63 539,54 €
102AlyssaGaylordAlyssa95@gmail.com92 963,65 €
103HelenMuellerHelen_Mueller@gmail.com51 704,43 €
104RonaldMoenRonald56@yahoo.com88 173,43 €
105GerardMcDermottGerard.McDermott@gmail.com79 616,46 €
106SamanthaZboncakSamantha_Zboncak@gmail.com75 298,13 €
107VanGleichnerVan.Gleichner99@hotmail.com90 917,71 €
108FrederickBodeFrederick.Bode44@gmail.com52 949,98 €
109LelaGutmannLela85@gmail.com52 247,22 €
110HarveyGutmannHarvey_Gutmann85@gmail.com82 998,73 €
111LuisRobelLuis.Robel21@gmail.com91 952,69 €
112BrandiWardBrandi_Ward@yahoo.com70 341,50 €
113MargieHillsMargie16@hotmail.com93 092,75 €
114TobyBeattyToby19@gmail.com66 829,50 €
115BobbyWardBobby.Ward@gmail.com82 475,01 €
116JasonBarrowsJason.Barrows@gmail.com87 777,57 €
117FrancisUllrichFrancis26@gmail.com69 615,22 €
118HermanMarquardtHerman.Marquardt51@yahoo.com84 744,26 €
119FrancisGleasonFrancis.Gleason35@hotmail.com58 666,45 €
120CarolynKunzeCarolyn_Kunze68@hotmail.com80 404,42 €
121TerryRogahnTerry_Rogahn62@gmail.com69 352,10 €
122KendraSengerKendra.Senger26@gmail.com93 641,61 €
123RochelleKesslerRochelle.Kessler@yahoo.com96 931,95 €
124YvonneHalvorsonYvonne63@hotmail.com94 598,15 €
125KendraBernhardKendra_Bernhard86@hotmail.com59 931,41 €
126KatherinePriceKatherine.Price22@hotmail.com60 998,60 €
127LillianWymanLillian_Wyman@yahoo.com52 545,83 €
128VelmaWunschVelma_Wunsch@yahoo.com74 742,06 €
129KristyHermanKristy.Herman@yahoo.com96 811,63 €
130ErickParkerErick15@gmail.com88 902,23 €
131DeanJohnstonDean.Johnston26@hotmail.com72 987,32 €
132PhillipBrekkePhillip.Brekke91@hotmail.com69 227,78 €
133AshleyBlickAshley32@hotmail.com74 736,25 €
134LarryFeeneyLarry42@hotmail.com76 448,86 €
135KaylaGloverKayla.Glover@gmail.com97 369,33 €
136AlvinSimonisAlvin.Simonis@gmail.com62 546,08 €
137KevinKassulkeKevin74@hotmail.com80 076,32 €
138TeresaO'KonTeresa.OKon40@yahoo.com87 065,63 €
139EllaCartwrightElla.Cartwright51@yahoo.com90 099,49 €
140AlbertHoweAlbert.Howe7@gmail.com50 647,80 €
141AndrewPfefferAndrew35@yahoo.com99 691,54 €
142GarrettJenkinsGarrett_Jenkins47@gmail.com56 963,04 €
143LouisKuvalisLouis.Kuvalis96@hotmail.com80 519,61 €
144MyrtleTrompMyrtle_Tromp@gmail.com69 930,94 €
145AndrewMurphyAndrew_Murphy42@gmail.com55 579,15 €
146PatriciaGaylordPatricia47@gmail.com89 805,17 €
147PrestonKuvalisPreston_Kuvalis3@hotmail.com83 615,78 €
148MerleOsinskiMerle4@yahoo.com92 220,65 €
149AlbertoBernhardAlberto.Bernhard41@gmail.com52 655,29 €
150DarrellBeattyDarrell51@hotmail.com54 224,58 €
151JoanneBartolettiJoanne.Bartoletti3@yahoo.com53 083,34 €
152GloriaBahringerGloria93@gmail.com65 360,79 €
153CameronHaneCameron_Hane76@gmail.com74 440,82 €
154ConradDooleyConrad77@hotmail.com79 099,12 €
155ErikMarksErik0@yahoo.com93 408,43 €
156CarolynWolffCarolyn2@hotmail.com97 583,81 €
157SilviaO'HaraSilvia78@gmail.com72 185,23 €
158DexterHettingerDexter_Hettinger@yahoo.com90 261,40 €
159MargaretLednerMargaret.Ledner38@yahoo.com62 783,44 €
160EllisHerzogEllis.Herzog4@gmail.com60 940,26 €
161MerleBahringerMerle.Bahringer92@hotmail.com53 660,05 €
162RobertoYostRoberto.Yost48@hotmail.com61 169,10 €
163StacyKuhlmanStacy98@yahoo.com93 823,76 €
164CoreyMonahanCorey_Monahan35@gmail.com57 966,22 €
165ChelseaSawaynChelsea_Sawayn51@yahoo.com52 049,90 €
166CliftonMillsClifton_Mills@gmail.com68 356,52 €
167TeriKlingTeri.Kling29@yahoo.com67 176,87 €
168TanyaFarrellTanya8@hotmail.com58 393,52 €
169MarianneCarrollMarianne.Carroll@yahoo.com92 390,80 €
170RosaliePurdyRosalie.Purdy19@gmail.com86 463,78 €
171ShirleyGreenfelderShirley_Greenfelder2@hotmail.com91 685,68 €
172DeloresSteuberDelores.Steuber50@hotmail.com94 113,92 €
173TerriKleinTerri.Klein96@hotmail.com68 647,08 €
174MarjorieBeahanMarjorie_Beahan75@hotmail.com84 706,53 €
175ReginaldReingerReginald_Reinger31@hotmail.com85 323,79 €
176KelleyBodeKelley.Bode39@gmail.com79 071,76 €
177LorenHowellLoren_Howell74@gmail.com93 204,93 €
178LindseySmithLindsey_Smith76@yahoo.com99 085,43 €
179DougWilkinsonDoug_Wilkinson41@yahoo.com79 267,68 €
180BernadetteWatsicaBernadette18@gmail.com77 302,18 €
181BillyVolkmanBilly93@gmail.com68 235,94 €
182CourtneyReingerCourtney59@yahoo.com54 541,73 €
183MarjorieDietrichMarjorie_Dietrich@yahoo.com51 211,89 €
184MeghanPollichMeghan71@gmail.com62 102,58 €
185PhillipSmithamPhillip_Smitham40@yahoo.com79 097,74 €
186VernaKlockoVerna.Klocko@gmail.com66 963,02 €
187RodolfoMertzRodolfo95@hotmail.com57 742,48 €
188SabrinaHyattSabrina.Hyatt0@yahoo.com82 874,64 €
189RogerLehnerRoger.Lehner20@gmail.com85 927,11 €
190JuliaHuelsJulia35@gmail.com67 309,00 €
191MayReynoldsMay52@yahoo.com96 990,64 €
192BennieWilliamsonBennie_Williamson@yahoo.com67 591,28 €
193EvanOkunevaEvan_Okuneva65@gmail.com79 220,93 €
194DianaRohanDiana.Rohan@gmail.com78 141,34 €
195ShariSmithamShari99@gmail.com60 195,83 €
196EllaSchillerElla_Schiller94@gmail.com83 482,98 €
197KarenTowneKaren_Towne54@hotmail.com54 088,60 €
198KellyJonesKelly.Jones46@gmail.com78 290,86 €
199RobinLeschRobin.Lesch@gmail.com66 805,27 €
200GuyMayertGuy.Mayert25@gmail.com68 127,67 €
201MistyOndrickaMisty.Ondricka33@yahoo.com75 954,94 €
202JuliusWhiteJulius43@gmail.com78 706,96 €
203JoshGaylordJosh_Gaylord48@hotmail.com60 487,10 €
204DebraJohnstonDebra.Johnston@gmail.com83 953,91 €
205KellieMarksKellie35@yahoo.com64 800,44 €
206TaylorGoodwinTaylor37@hotmail.com83 261,10 €
207LeeMetzLee58@gmail.com98 403,81 €
208EddieMurazikEddie36@hotmail.com68 029,89 €
209ErnestoMcLaughlinErnesto_McLaughlin60@gmail.com99 436,01 €
210LaurenceTurnerLaurence_Turner87@gmail.com51 909,85 €
211HazelVandervortHazel74@gmail.com94 267,75 €
212CeceliaNaderCecelia.Nader@gmail.com74 472,40 €
213PhilLednerPhil_Ledner@yahoo.com68 881,51 €
214KrystalMetzKrystal.Metz@gmail.com83 250,52 €
215DonAltenwerthDon.Altenwerth32@gmail.com52 897,75 €
216CandaceMcCulloughCandace69@hotmail.com96 247,14 €
217SabrinaGulgowskiSabrina.Gulgowski68@gmail.com50 276,69 €
218LaurenceBatzLaurence3@yahoo.com64 410,12 €
219ShaneRippinShane.Rippin@hotmail.com75 551,08 €
220BernadetteMorissetteBernadette98@hotmail.com98 512,13 €
221AlexanderWestAlexander_West@gmail.com61 698,25 €
222StellaMcKenzieStella.McKenzie@yahoo.com78 466,06 €
223ArleneParkerArlene.Parker62@yahoo.com57 641,64 €
224BrettDurganBrett14@hotmail.com67 162,65 €
225MurielTremblayMuriel.Tremblay@yahoo.com78 588,45 €
227LesterBartellLester_Bartell@gmail.com59 093,66 €
228CristinaStreichCristina54@gmail.com81 916,04 €
229ErnestineHeathcoteErnestine.Heathcote31@yahoo.com71 069,20 €
230ClarenceEmardClarence_Emard67@gmail.com82 071,65 €
231MonaKertzmannMona4@hotmail.com56 353,15 €
232TraceyPfefferTracey_Pfeffer@gmail.com91 484,81 €
233TonyHartmannTony_Hartmann93@yahoo.com80 992,77 €
234HarryTreutelHarry.Treutel@hotmail.com51 423,99 €
235ErvinTillmanErvin_Tillman17@yahoo.com82 561,69 €
236DerekSchoenDerek.Schoen79@hotmail.com95 956,53 €
237AnthonyPriceAnthony.Price62@gmail.com74 884,58 €
238ShariZboncakShari_Zboncak@gmail.com96 737,83 €
239GlennLeannonGlenn_Leannon50@gmail.com63 534,18 €
240GuyTreutelGuy_Treutel@gmail.com60 108,71 €
241AngieHoppeAngie_Hoppe@hotmail.com65 635,04 €
242CatherineBartellCatherine98@yahoo.com98 196,01 €
243TimmyTorpTimmy_Torp0@yahoo.com54 958,10 €
244WalterSchimmelWalter_Schimmel94@hotmail.com51 050,65 €
245CeciliaLakinCecilia32@yahoo.com95 127,62 €
246ColinReichelColin17@yahoo.com66 112,87 €
247VictoriaDeckowVictoria.Deckow@gmail.com60 492,50 €
248HomerCormierHomer19@hotmail.com90 229,04 €
249SpencerO'ReillySpencer34@yahoo.com60 243,52 €
250AllanHandAllan.Hand@gmail.com59 170,08 €
251CameronOndrickaCameron.Ondricka@gmail.com79 858,60 €
252MarkBinsMark.Bins@hotmail.com52 790,83 €
253JaimeJacobsonJaime_Jacobson@yahoo.com76 493,75 €
254IrmaWatsicaIrma_Watsica10@yahoo.com58 546,05 €
255ShaunBraunShaun83@gmail.com59 642,92 €
256DianaEffertzDiana83@gmail.com82 583,67 €
257StevenDooleySteven_Dooley@yahoo.com64 657,62 €
258IrmaKovacekIrma.Kovacek@hotmail.com94 208,96 €
259EmmettHerzogEmmett_Herzog@yahoo.com67 817,81 €
260KellyDavisKelly_Davis@yahoo.com71 400,98 €
261LuzMorarLuz24@gmail.com64 577,48 €
262MartaHarrisMarta.Harris@gmail.com66 971,72 €
263MabelWolffMabel_Wolff@gmail.com74 724,96 €
264SamuelGutkowskiSamuel_Gutkowski50@gmail.com60 034,46 €
265EmmaEmmerichEmma.Emmerich39@hotmail.com72 648,66 €
266IrvinMitchellIrvin_Mitchell@yahoo.com50 003,10 €
267NicolasHalvorsonNicolas.Halvorson@hotmail.com71 526,27 €
268CharlieJerdeCharlie3@gmail.com73 030,99 €
269RamonaDibbertRamona_Dibbert81@hotmail.com74 358,11 €
270CliftonKleinClifton_Klein@gmail.com97 270,09 €
271StellaSteuberStella_Steuber25@gmail.com59 692,64 €
272JuanitaChamplinJuanita.Champlin@yahoo.com72 780,75 €
273IsaacStammIsaac.Stamm96@hotmail.com69 292,97 €
274DoyleSchummDoyle63@gmail.com51 427,45 €
275ClayGrimesClay20@gmail.com51 772,08 €
276RolandMayertRoland_Mayert6@hotmail.com81 883,80 €
277EdmondBahringerEdmond.Bahringer16@hotmail.com50 929,17 €
278RandallDanielRandall.Daniel@gmail.com89 905,30 €
279GregorySpencerGregory.Spencer31@hotmail.com74 161,60 €
280OwenSwaniawskiOwen5@yahoo.com95 707,25 €
281LavernePacochaLaverne_Pacocha5@yahoo.com65 789,34 €
282SaraShieldsSara.Shields@yahoo.com86 180,98 €
283ChristianHoegerChristian.Hoeger13@gmail.com71 363,32 €
284DamonDenesikDamon.Denesik22@hotmail.com55 400,84 €
285MarjorieEmmerichMarjorie.Emmerich@yahoo.com63 652,59 €
286TashaBorerTasha57@gmail.com94 186,62 €
287JosephKrisJoseph16@hotmail.com67 814,68 €
288BethanyBeerBethany_Beer@yahoo.com65 998,18 €
289TerranceThielTerrance.Thiel@yahoo.com80 137,01 €
290BobCasperBob_Casper31@yahoo.com68 748,43 €
291JoeLakinJoe_Lakin@yahoo.com98 278,19 €
292LeeWolffLee_Wolff13@gmail.com94 738,69 €
293AlvinSmithAlvin.Smith@gmail.com68 593,23 €
294JimmieDietrichJimmie_Dietrich49@yahoo.com84 267,88 €
295TyroneDachTyrone_Dach86@gmail.com94 728,32 €
296VanMillsVan.Mills@hotmail.com60 109,47 €
297TedGibsonTed.Gibson8@gmail.com65 825,81 €
298RoxanneKuhnRoxanne_Kuhn@hotmail.com79 023,74 €
299ReginaKeelingRegina41@gmail.com66 369,94 €
300HelenWittingHelen.Witting@yahoo.com74 575,87 €
301OliverDanielOliver.Daniel0@hotmail.com54 641,11 €
302DougLeannonDoug.Leannon77@yahoo.com76 076,55 €
303CarolSchmelerCarol49@hotmail.com83 833,88 €
304DonMillsDon9@gmail.com53 632,72 €
305LindseyConsidineLindsey_Considine@gmail.com98 571,25 €
306GraceNaderGrace.Nader18@gmail.com82 399,49 €
307CandiceRodriguezCandice_Rodriguez2@yahoo.com90 887,74 €
308LulaSchultzLula_Schultz27@hotmail.com97 039,29 €
309LeeBinsLee_Bins@gmail.com71 842,44 €
310SaulHoweSaul5@yahoo.com52 676,35 €
311LouiseGislasonLouise.Gislason@yahoo.com88 305,26 €
312MyrtleHackettMyrtle.Hackett3@gmail.com68 996,49 €
313CaseyZemlakCasey.Zemlak71@yahoo.com57 259,51 €
314KristenHuelKristen.Huel@gmail.com54 689,50 €
315KristaKrisKrista_Kris@hotmail.com93 758,65 €
316DanielleJerdeDanielle_Jerde10@gmail.com99 301,40 €
317AngelicaTremblayAngelica.Tremblay70@yahoo.com85 313,90 €
318LouiseAbshireLouise69@gmail.com77 784,92 €
319WmBogisichWm35@hotmail.com62 126,09 €
320MaryannWisokyMaryann.Wisoky78@yahoo.com85 135,69 €
321BetsyWisozkBetsy.Wisozk@gmail.com77 627,62 €
322AlexanderStoltenbergAlexander_Stoltenberg@gmail.com99 611,36 €
323JudithFlatleyJudith.Flatley@hotmail.com77 310,19 €
324StewartTreutelStewart_Treutel@gmail.com50 889,65 €
325HelenSchillerHelen.Schiller83@yahoo.com73 442,69 €
326HeidiHaagHeidi_Haag@yahoo.com51 397,29 €
327RossThielRoss.Thiel58@hotmail.com92 754,54 €
328AmandaSengerAmanda.Senger@hotmail.com89 441,31 €
329BethHilpertBeth.Hilpert48@hotmail.com62 114,78 €
330CurtisHesselCurtis.Hessel@yahoo.com57 498,77 €
331AlmaGibsonAlma_Gibson37@hotmail.com90 762,65 €
332JeannetteSchadenJeannette.Schaden97@yahoo.com96 075,03 €
333RobertoHermanRoberto.Herman@hotmail.com97 894,29 €
334ClarenceBlandaClarence_Blanda@hotmail.com50 450,45 €
335JefferyKassulkeJeffery_Kassulke97@hotmail.com55 046,88 €
336TrevorSchuppeTrevor.Schuppe@hotmail.com80 338,20 €
337RonLebsackRon_Lebsack24@gmail.com55 184,82 €
338CedricAuerCedric_Auer@gmail.com67 321,90 €
339GinaSchillerGina.Schiller@gmail.com89 055,19 €
340JuliusSchmidtJulius.Schmidt29@gmail.com69 183,31 €
341BrandiCorkeryBrandi84@yahoo.com67 152,53 €
342AliciaMcClureAlicia47@yahoo.com93 251,90 €
343MicheleWatersMichele.Waters93@gmail.com92 624,38 €
344KristenHoegerKristen89@yahoo.com60 848,20 €
345KateHeathcoteKate.Heathcote@yahoo.com62 751,58 €
346RudolphLefflerRudolph.Leffler@gmail.com90 085,95 €
347GarryMcCulloughGarry.McCullough81@gmail.com87 440,86 €
348TraceyRutherfordTracey.Rutherford77@hotmail.com71 584,47 €
349ShellyBartolettiShelly_Bartoletti@hotmail.com95 964,97 €
350JohnnyPadbergJohnny79@gmail.com91 804,24 €
351DavidSmithamDavid.Smitham34@hotmail.com68 092,90 €
352PriscillaConroyPriscilla_Conroy@hotmail.com92 922,27 €
353ShannonEmardShannon37@hotmail.com53 804,17 €
354PaulaKautzerPaula73@hotmail.com53 365,86 €
355JayDouglasJay.Douglas93@yahoo.com62 473,03 €
356WesleyTorphyWesley.Torphy7@gmail.com54 390,81 €
357LorraineWilliamsonLorraine.Williamson@hotmail.com80 333,70 €
358JohannaHahnJohanna97@hotmail.com55 954,42 €
359AlexanderMertzAlexander4@gmail.com99 571,59 €
360WilsonBruenWilson1@gmail.com64 776,40 €
361HubertPfannerstillHubert14@hotmail.com63 008,59 €
362AlanO'KonAlan23@hotmail.com80 885,59 €
363WillieMetzWillie1@yahoo.com51 930,24 €
364JoeyFerryJoey.Ferry@hotmail.com94 608,69 €
365RickyHermannRicky.Hermann@gmail.com83 772,49 €
366DevinStammDevin47@yahoo.com94 867,24 €
367JoshuaHomenickJoshua_Homenick14@gmail.com76 817,11 €
368LarryDaughertyLarry_Daugherty@hotmail.com73 207,94 €
369ClaudeGleasonClaude_Gleason66@hotmail.com85 370,52 €
370SammyMurazikSammy.Murazik@yahoo.com69 384,89 €
371AngelinaAbshireAngelina76@yahoo.com60 717,13 €
372TashaKunzeTasha_Kunze@gmail.com64 904,36 €
373LulaCollierLula_Collier@gmail.com90 212,24 €
374DeannaStiedemannDeanna.Stiedemann@yahoo.com78 268,35 €
375ShelleyJohnsShelley_Johns@gmail.com87 217,90 €
376AlbertLittleAlbert97@yahoo.com81 290,85 €
377CarlosReichelCarlos68@yahoo.com98 138,19 €
378EbonySchillerEbony22@yahoo.com68 048,74 €
379AndrewSchultzAndrew_Schultz@gmail.com60 699,23 €
380EbonyStrosinEbony_Strosin67@gmail.com62 514,96 €
381JanetHauckJanet_Hauck@hotmail.com84 912,58 €
382DarrylBartonDarryl.Barton@gmail.com52 279,26 €
383LawrenceReillyLawrence.Reilly@hotmail.com69 375,45 €
384MerleAbbottMerle.Abbott@hotmail.com68 595,59 €
385HugoO'ConnerHugo_OConner@yahoo.com83 359,23 €
386JaniceRodriguezJanice65@gmail.com80 747,25 €
387SabrinaRohanSabrina.Rohan@gmail.com87 173,33 €
388CarrieRutherfordCarrie.Rutherford@hotmail.com60 272,93 €
389DexterMayertDexter_Mayert@yahoo.com76 548,50 €
390NeilCollierNeil92@gmail.com65 578,63 €
391KurtHudsonKurt_Hudson@hotmail.com69 301,70 €
392TraciBogisichTraci.Bogisich@yahoo.com66 958,98 €
393MargieWisokyMargie_Wisoky21@hotmail.com73 741,48 €
394TonyaFaheyTonya_Fahey@gmail.com67 174,49 €
395RobinCummingsRobin_Cummings18@hotmail.com58 248,04 €
396EbonyDooleyEbony.Dooley@yahoo.com95 321,75 €
397KerryKiehnKerry_Kiehn@hotmail.com62 090,55 €
398EdmondZulaufEdmond.Zulauf7@hotmail.com71 307,08 €
399DarrelRennerDarrel64@yahoo.com97 531,20 €
400SamuelHintzSamuel_Hintz59@yahoo.com56 505,23 €
401MiltonSpencerMilton.Spencer59@yahoo.com74 456,00 €
402RamonaKirlinRamona.Kirlin5@hotmail.com94 970,73 €
403BerniceWiegandBernice48@yahoo.com52 033,04 €
404EliasHoweElias.Howe0@yahoo.com97 651,27 €
405RobertoYundtRoberto.Yundt6@gmail.com62 652,13 €
406RosemarySchaeferRosemary_Schaefer30@yahoo.com68 839,52 €
407TerryHaleyTerry.Haley@hotmail.com86 348,42 €
408SheriMitchellSheri0@hotmail.com57 715,42 €
409PerryKingPerry_King@yahoo.com61 518,62 €
410BettyBotsfordBetty80@gmail.com97 322,93 €
411LouisWeimannLouis85@gmail.com60 939,34 €
412MarshallHeidenreichMarshall_Heidenreich@yahoo.com88 487,45 €
413LoisKochLois.Koch@yahoo.com56 886,70 €
414AltonSchultzAlton.Schultz16@yahoo.com87 849,82 €
415BryantCorwinBryant_Corwin@yahoo.com63 545,35 €
416ScottSchinnerScott_Schinner@gmail.com63 194,44 €
417KarlaKrajcikKarla.Krajcik@yahoo.com78 536,72 €
418AlfredoVandervortAlfredo4@yahoo.com60 981,53 €
419WesleyColeWesley97@gmail.com63 627,14 €
420KristieHaneKristie.Hane28@hotmail.com72 576,80 €
421JonathanHaagJonathan_Haag@yahoo.com67 395,58 €
422ShawnRatkeShawn.Ratke88@gmail.com71 156,76 €
423EddieMetzEddie81@gmail.com60 392,26 €
424FrancesBinsFrances_Bins@gmail.com50 298,35 €
425TonyPfefferTony_Pfeffer23@yahoo.com65 389,46 €
426YolandaSchusterYolanda.Schuster@gmail.com99 616,45 €
427LanaHalvorsonLana34@yahoo.com59 606,46 €
428AliciaBradtkeAlicia_Bradtke@gmail.com96 629,57 €
429AmosBaumbachAmos.Baumbach68@gmail.com70 157,76 €
430FloydRaynorFloyd.Raynor@hotmail.com81 088,19 €
431JonJenkinsJon.Jenkins37@gmail.com57 446,39 €
432EliasKuphalElias.Kuphal47@gmail.com75 968,29 €
433PedroPredovicPedro_Predovic97@gmail.com79 226,86 €
434JessicaHeathcoteJessica_Heathcote72@gmail.com61 143,89 €
435LindseyKovacekLindsey.Kovacek6@gmail.com97 743,51 €
436TylerGreenfelderTyler15@gmail.com95 764,51 €
437MarionKautzerMarion.Kautzer98@yahoo.com68 247,16 €
438JanieMarvinJanie.Marvin@hotmail.com59 593,98 €
439NathanBartonNathan_Barton61@hotmail.com98 958,20 €
440CeliaHagenesCelia5@yahoo.com55 858,97 €
441DelbertLubowitzDelbert66@yahoo.com59 267,64 €
442KellyMedhurstKelly.Medhurst21@yahoo.com63 280,53 €
443RalphLueilwitzRalph95@gmail.com50 350,17 €
444CaryYostCary52@yahoo.com96 934,71 €
445LonnieBashirianLonnie_Bashirian@gmail.com76 109,23 €
446ClaireBrownClaire.Brown55@gmail.com63 015,21 €
447GraceHarberGrace.Harber@hotmail.com76 656,79 €
448JanieMaggioJanie.Maggio@hotmail.com75 100,48 €
449LoraWolfLora_Wolf@yahoo.com62 790,08 €
450ErmaLindgrenErma67@gmail.com50 992,38 €
451ErikCruickshankErik6@yahoo.com85 137,26 €
452WilburGrimesWilbur2@hotmail.com61 844,22 €
453ShawnaParisianShawna.Parisian@gmail.com85 909,02 €
454CindyGislasonCindy8@yahoo.com55 927,69 €
455JulioBeerJulio.Beer70@gmail.com84 416,72 €
456CaroleHintzCarole.Hintz12@yahoo.com67 774,26 €
457GrantZiemeGrant.Zieme25@yahoo.com55 139,48 €
458BennyTurcotteBenny.Turcotte57@hotmail.com77 752,90 €
459MartyPredovicMarty_Predovic33@yahoo.com88 693,35 €
460EloiseCartwrightEloise93@hotmail.com67 841,90 €
461BertMacejkovicBert_Macejkovic84@hotmail.com70 948,62 €
462LuisHansenLuis48@yahoo.com57 917,28 €
463NoahSchinnerNoah_Schinner65@gmail.com70 205,07 €
464DonSwiftDon31@gmail.com83 846,08 €
465AlyssaPollichAlyssa.Pollich55@hotmail.com92 025,52 €
466CraigWildermanCraig.Wilderman16@yahoo.com74 374,66 €
467AndresJenkinsAndres.Jenkins@yahoo.com68 743,52 €
468GuyLeschGuy.Lesch65@gmail.com59 731,59 €
469EugeneGoldnerEugene22@hotmail.com88 579,25 €
470LindsayMarksLindsay29@gmail.com56 124,81 €
471TanyaHintzTanya.Hintz@yahoo.com70 772,36 €
472MaxCummerataMax.Cummerata45@gmail.com91 507,36 €
473PatsyChristiansenPatsy.Christiansen58@yahoo.com86 900,25 €
474RuthBruenRuth_Bruen25@gmail.com93 391,25 €
475TomColeTom_Cole16@yahoo.com60 015,88 €
476CharleneGoyetteCharlene5@hotmail.com75 040,63 €
477TedMannTed.Mann@gmail.com77 324,64 €
478GeorgeFerryGeorge_Ferry@gmail.com86 090,05 €
479HoraceStarkHorace75@gmail.com75 461,10 €
480SandyKozeySandy64@gmail.com61 485,46 €
481RichardHodkiewiczRichard_Hodkiewicz62@gmail.com81 577,34 €
482AngelinaRutherfordAngelina0@gmail.com85 489,63 €
483AudreyChristiansenAudrey74@hotmail.com99 398,50 €
484EllaLittelElla5@hotmail.com65 535,18 €
485GinaBruenGina60@gmail.com50 564,33 €
486CarolynNolanCarolyn.Nolan@yahoo.com69 736,17 €
487BerniceLabadieBernice64@yahoo.com72 465,56 €
488KrystalPurdyKrystal_Purdy86@hotmail.com79 207,99 €
489TommieBrakusTommie.Brakus@yahoo.com98 868,50 €
490BernardWehnerBernard_Wehner@gmail.com93 934,24 €
491CaseyTerryCasey_Terry65@gmail.com69 148,67 €
492ConnieHansenConnie.Hansen@hotmail.com63 577,44 €
493LoraStrosinLora_Strosin@gmail.com53 705,29 €
494GrantKlockoGrant.Klocko96@yahoo.com87 161,39 €
495TerranceMonahanTerrance22@yahoo.com93 972,86 €
496TroyRitchieTroy11@gmail.com67 831,12 €
497DeannaKlockoDeanna_Klocko@hotmail.com69 116,80 €
498SusieCasperSusie.Casper52@yahoo.com53 448,48 €
499DeannaGreenholtDeanna_Greenholt20@hotmail.com62 398,17 €
Total emails: 00,00 €
<DataGrid TItem="Employee"
          Data="@employeeList"
          ReadData="@OnReadData"
          TotalItems="@totalEmployees"
          AggregateData="@employeeSummary"
          Responsive>
    <DataGridAggregates>
        <DataGridAggregate TItem="Employee" Field="@nameof( Employee.Email )" Aggregate="DataGridAggregateType.Count">
            <DisplayTemplate>
                @($"Total emails: {context.Value}")
            </DisplayTemplate>
        </DataGridAggregate>
        <DataGridAggregate TItem="Employee" Field="@nameof( Employee.Salary )" Aggregate="DataGridAggregateType.Sum" DisplayFormat="{0:C}" DisplayFormatProvider="@System.Globalization.CultureInfo.GetCultureInfo("fr-FR")" />
        <DataGridAggregate TItem="Employee" Field="@nameof( Employee.IsActive )" Aggregate="DataGridAggregateType.TrueCount" />
    </DataGridAggregates>
    <DataGridColumns>
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.Id)" Caption="#" Sortable="false" />
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.FirstName)" Caption="First Name" Editable="true" />
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.LastName)" Caption="Last Name" Editable="true" />
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.Email)" Caption="Email" Editable="true" />
        <DataGridColumn TItem="Employee" Field="@nameof(Employee.Salary)" Caption="Salary" DisplayFormat="{0:C}" DisplayFormatProvider="@System.Globalization.CultureInfo.GetCultureInfo("fr-FR")" Editable="true">
            <EditTemplate>
                <NumericEdit TValue="decimal" Value="@((decimal)context.CellValue)" ValueChanged="@( v => context.CellValue = v)" />
            </EditTemplate>
        </DataGridColumn>
    </DataGridColumns>
</DataGrid>
@code{
    [Inject]
    public EmployeeData EmployeeData { get; set; }
    private List<Employee> employeeList;

    protected override async Task OnInitializedAsync()
    {
        employeeList = await EmployeeData.GetDataAsync();
        await base.OnInitializedAsync();
    }

    private int totalEmployees;
    private List<Employee> employeeSummary;

    private Task OnReadData( DataGridReadDataEventArgs<Employee> e )
    {
        if ( !e.CancellationToken.IsCancellationRequested )
        {
            List<Employee> response = null;

            // this can be call to anything, in this case we're calling a fictional api
            //var response = await Http.GetJsonAsync<Employee[]>( $"some-api/employees?page={e.Page}&pageSize={e.PageSize}" );
            if ( e.ReadDataMode is DataGridReadDataMode.Virtualize )
                response = employeeList.Skip( e.VirtualizeOffset ).Take( e.VirtualizeCount ).ToList();
            else if ( e.ReadDataMode is DataGridReadDataMode.Paging )
                response = employeeList.Skip( ( e.Page - 1 ) * e.PageSize ).Take( e.PageSize ).ToList();
            else
                throw new Exception( "Unhandled ReadDataMode" );


            if ( !e.CancellationToken.IsCancellationRequested )
            {
                totalEmployees = employeeList.Count;
                employeeList = new List<Employee>( response ); // an actual data for the current page
                                                               //var aggregateResponse = await Http.GetJsonAsync<Employee[]>( $"some-aggregate-api/employees" );
                employeeSummary = employeeList; //aggregateResponse.Data
            }
        }
        return Task.CompletedTask;
    }
}