$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