i have a csv file with following informations and want to use powershell to reach my goal. Every month i create this report and i want to group it and sum up the total pages.

In the end, i want to see which user printed on what printer how many total pages over a month.

So i use the group-object 'Full Name',Printer Name' but how can i sum up the total pages according to that group?

Best regards, Manuel

CodePudding user response：

Measure-Object can be used to sum, average, minimum and maximum

Import-Csv C:\ps\sampled.csv | Group-Object 'Full Name' | 
Select-Object 'Name', @{ n='Total Pages'; e={ ($_.Group | Measure-Object 'Total Pages' -Sum).Sum } }