销售清单数据透视表模板.xls

员工编号(全部)销售日期(全部)数据规格型号姓名求和项:单价求和项:销售数量求和项:销售数额3100胡冬75064500李佳75053750刘松75064500张梦750645003220李佳1300791006021刘松165058250曾艾1650349506030胡冬110055500李佳110033300曾艾110066600张梦1100444006170曾艾177035310张梦1770235406255曾艾1660233206670胡冬250025000李佳250025000刘松2500250008800刘松7570175709500刘松530015300总计3757071993903 3月月份份销销售售数数据据统统计计清清单单员工编号姓名销售日期规格型号单价销售数量 销售数额0002刘松2006/3/195005300153000001李佳2006/3/33100750537500003曾艾2006/3/561701770353100004胡冬2006/3/63100750645000002刘松2006/3/760211650582500005张梦2006/3/93100750645000001李佳2006/3/1060301100333000003曾艾2006/3/1060301100666000002刘松2006/3/1288007570175700001李佳2006/3/1666702500250000002刘松2006/3/183100750645000004胡冬2006/3/1860301100555000003曾艾2006/3/1962551660233200005张梦2006/3/2061701770235400003曾艾2006/3/2560211650349500004胡冬2006/3/2566702500250000002刘松2006/3/2666702500250000001李佳2006/3/2732201300791000005张梦2006/3/276030110044400