首页 > 代码库 > EXCEL Pivot table manipulate

EXCEL Pivot table manipulate

Add filter

For the Demo time,I would like to filter out the products which not in Red and Black color.

My operation followed underneath.

1.Click the color dimension,cancel the Red and Black checkbox,



2.Drag the "Color" Dimension to Filters




3.The data shows on pivot table is being filtered now