[Aggregate PowerShell Objects] How to use measuring and grouping to calculate the group counts of a powershell object. This can be useful for preaggregation of totals before exporting to excel for example #powershell

measure-powershell-objects.ps1

$Companies = @(
    [pscustomobject]@{CompanyName = 'Foo'; UserCount = 5 }
    [pscustomobject]@{CompanyName = 'Foo1'; UserCount = 5 }
    [pscustomobject]@{CompanyName = 'Foo'; UserCount = 2 }
    [pscustomobject]@{CompanyName = 'Foo'; UserCount = 3 }
)

$CalculatedResults = $Companies |  Group-Object CompanyName | ForEach-Object {
    $i = $_
    [int]$totalusers = ($i.Group | Measure-Object -Sum -Property UserCount).Sum

    [pscustomobject]@{
        CompanyName = $i.Name
        TotalUsers  = $totalUsers
    }
}
Write-Host "#####################"
Write-Host "Unaggregated Results"
Write-Host "$($Companies | Format-Table -Autosize -Wrap | Out-String)"
Write-Host "#####################"
Write-Host "`n`n`n`n"
Write-Host "#####################"
Write-Host "Calculated Results"
Write-Host "$($CalculatedResults | Format-Table -AutoSize -Wrap | Out-String)"
Write-Host "#####################"