案例12-数据透视表

编号销售日期商品品牌型号单价数量金额销售人员KF012009/2/1服务器联想万全R51024000372000张强KF022009/2/1服务器IBMX3468840-I0223900247800周涛KF032009/2/1台式机联想天骄E5001X850024204000林帆KF042009/2/1笔记本电脑方正I55014000570000刘丽KF052009/2/16服务器IBMX3468840-I022390003717000周涛KF062009/2/16台式机方正商祺3200460026119600丁一KF072009/2/16笔记本电脑联想昭阳S62012000560000周涛KF082009/2/22台式机联想天骄E5001X850022187000刘丽KF092009/2/22服务器联想万全R510240006144000张强KF102009/2/22台式机联想天骄E5001X700040280000刘丽KF112009/3/2笔记本电脑联想昭阳S62012000896000张强KF122009/3/2台式机方正商祺3200760033250800周涛KF132009/3/2笔记本电脑联想昭阳S6201200010120000张强KF142009/3/10台式机联想天骄E5001X700027189000林帆KF152009/3/10服务器IBMxSerics23524300372900周涛KF162009/3/10笔记本电脑方正T66014000684000林帆KF172009/3/10笔记本电脑联想昭阳S620120009108000刘丽KF182009/3/11台式机方正商祺R260460030138000丁一KF192009/3/11台式机联想天骄E5001X850026221000丁一KF202009/3/11服务器联想万全I3503220011354200周涛KF212009/4/15笔记本电脑方正T66014000798000刘丽KF222009/4/15台式机方正商祺3200760045342000张强KF232009/4/15台式机联想锋行K7010A760040304000周涛KF242009/4/15服务器IBMxSerics23524300248600周涛KF252009/4/16服务器联想万全I35032200132200林帆KF262009/4/16台式机方正商祺320076001076000张强KF272009/4/16笔记本电脑联想昭阳S62012000224000张强KF282009/4/30台式机联想锋行K7010A760021159600林帆KF292009/5/8服务器IBMX2558685-71471004188400林帆KF302009/5/8笔记本电脑方正E400910021191100周涛商品销售统计表销售人员刘丽求和项:数量列标签行标签方正联想总计2月562673月994月77总计127183