Examples/PivotTableFilters/testPivotFilter.ps1
|
try {Import-Module $PSScriptRoot\..\..\ImportExcel.psd1} catch {throw ; return} $xlFile="$env:TEMP\testPivot.xlsx" Remove-Item $xlFile -ErrorAction Ignore $data =@" Region,Area,Product,Units,Cost North,A1,Apple,100,.5 South,A2,Pear,120,1.5 East,A3,Grape,140,2.5 West,A4,Banana,160,3.5 North,A1,Pear,120,1.5 North,A1,Grape,140,2.5 "@ | ConvertFrom-Csv $data | Export-Excel $xlFile -Show ` -AutoSize -AutoFilter ` -IncludePivotTable ` -PivotRows Product ` -PivotData @{"Units"="sum"} -PivotFilter Region, Area -Activate <# Creates a Pivot table that looks like Region All^ Area All^ Sum of Units Row Labels Total Apple 100 Pear 240 Grape 280 Banana 160 Grand Total 780 #> |