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

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