EXCEL Pivot table manipulate

时间:2024-12-20 22:03:56

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,

EXCEL Pivot table manipulate

2.Drag the "Color" Dimension to Filters

EXCEL Pivot table manipulate

EXCEL Pivot table manipulate

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

版权声明:本文博主原创文章,博客,未经同意不得转载。