首页 > 其他 > 详细

EXCEL Pivot table manipulate

时间:2014-07-17 17:03:06      阅读:360      评论:0      收藏:0      [点我收藏+]

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,

bubuko.com,布布扣


2.Drag the "Color" Dimension to Filters

bubuko.com,布布扣

bubuko.com,布布扣


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


EXCEL Pivot table manipulate,布布扣,bubuko.com

EXCEL Pivot table manipulate

原文:http://blog.csdn.net/lglgsy456/article/details/37905609

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!