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,

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

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

上一篇:[Javascript] Manipulate the DOM with the classList API


下一篇:日期计算、正则、sequence、索引、表连接、mybatis