Powershell export to pivot table
Export from powershell to generate a pivot table in excel.
et-Process | Where Company | Export-Excel C:\ps.xlsx -Show -IncludePivotTable -PivotRows Company -PivotData @{Handles=”sum”} -IncludePivotChart -ChartType PieExploded3D