Pivot Sort

[dfinke]

Discussed in #1306

^{Originally posted by RoYoMi November 12, 2022}
I have created a pivot table but it don't see a way to make it sort the output by the Grand Total field.

In Excel I can manually right click the a total field and choose sort.

Here is my setup:

 $Excel = $Output.RawData `
       | Select-Object @{n="Date"; e={$_.Date | Get-Date}}, @{n="DateYM"; e={$_.Date | Get-Date -Format "yyyy`nMMM"}}, ComputerName, DisplayName, Commandlet, ModuleVersion, Event, FullCommand `
       | Export-Excel $ExcelFile @ExportExcelOptions -Passthru

    $PivotTableOptions = @{
        ExcelPackage        = $Excel
        PivotTableName      = "ByCommand"
        SourceWorkSheet     = $Excel.Sheet1
        PivotRows           = "Commandlet"
        PivotData           = @{"Commandlet" = "Count"}
        PivotColumns        = @("DateYM")
        PivotTotals         = "Both"
        PivotTableStyle     = "Light16"
        }
    $pt = Add-PivotTable @PivotTableOptions -PassThru

That code creates this:

I found this teaser in v5.3 where it talks about sort on pivot tables, but I can't figure it out.

Did I miss something in the docs?
Or is this even possible?

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.