$xl = $data | Export-Excel -Path .\demo.xlsx -WorkSheetname "Source Data" -PassThru $Pt1 = New-PivotTableDefinition -PivotTableName "Compute" -PivotData @{"NumCPU" ="Average"} @{"MemoryGB" ="Average"} -SourceWorkSheet "Source Data" ` -PivotRows Year,Month,PowerState,Name,Day,Time $xl = Export-Excel -ExcelPackage $xl -WorkSheetname "Resource Summary" -PivotTableDefinition $Pt1 WARNING: Could not add 'Average of CPUs' to Columns in PivotTable Compute. WARNING: Problem adding data fields to PivotTable Compute. $xl = $data | Export-Excel -Path .\demo.xlsx -WorkSheetname "Source Data" -PassThru $xl = Export-Excel -ExcelPackage $xl -WorkSheetname "Resource Summary" -PivotTableDefinition $Pt1 WARNING: Problem adding data fields to PivotTable Compute. $Pt1 = New-PivotTableDefinition -PivotTableName "Compute" -PivotData @{"NumCPU" ="Average"} -SourceWorkSheet "Source Data" ` -PivotRows Year,Month,PowerState,Name -PivotColumns 'NumCPU' $xl = $data | Export-Excel -Path .\demo.xlsx -WorkSheetname "Source Data" -PassThru $Pt1 = New-PivotTableDefinition -PivotTableName "Compute" -PivotData @{"NumCPU" ="Average"} -SourceWorkSheet "Source Data" ` -PivotRows Year,Month,PowerState,Name -PivotColumns 'NumCPU' $xl = Export-Excel -ExcelPackage $xl -WorkSheetname "Resource Summary" -PivotTableDefinition $Pt1 $xl = $data | Export-Excel -Path .\demo.xlsx -WorkSheetname "Source Data" -PassThru $Pt1 = New-PivotTableDefinition -PivotTableName "Compute" -PivotData @{"NumCPU" ="Average";"MemoryGB" ="Average"} -SourceWorkSheet "Source Data" ` -PivotRows Year,Month,PowerState,Name,Day -PivotColumns NumCPU,MemoryGB $xl = Export-Excel -ExcelPackage $xl -WorkSheetname "Resource Summary" -PivotTableDefinition $Pt1