search

dfinke / ImportExcel

PowerShell module to import/export Excel spreadsheets, without Excel
https://www.powershellgallery.com/packages/ImportExcel/
Apache License 2.0
2.47k stars 400 forks source link

Top 10 Filter #1270

Closed Dave-The-Tech closed 2 years ago

Dave-The-Tech commented 2 years ago

Hello, I would like to know if its possible to add filter to a pivot table to only display the top 10 items. Similar to this menu: image

Cheers,

dfinke commented 2 years ago

No, this is not doable. The EPPlus library used does not support it. The new EPPlus does support it, but they have fixed many things which caused breaking changes and their library is no longer free.