搜索
求和项:借方部门发生日期科目名称一室七室十室总计工会经费6517.57635.0618485.2332637.79公积金282964734949518125163教育经费4888.135726.3113863.9524478.39失业保险1944318431388266招待费32783.8527288.37493.9467566.0974429.4891182.6792499.12258111.27工会经费3015.395201.6710276.8518493.91公积金282964351651465123277教育经费2261.553901.277707.6413870.46失业保险1944286233248130招待费46850.1345103.523886.78115840.4182367.07100584.4496660.27279611.78工会经费6223.317439.122635.1936297.6公积金351815138663405149972教育经费4667.495579.3416976.4127223.24失业保险1895.82823.623257.187976.6招待费32704.451386.1827613111703.5880672118614.24133886.78333173.02工会经费3453.916875.3519995.4530324.71公积金394286323285286187946教育经费2590.435156.5314996.5922743.55失业保险2317.644100.547575.6413993.82招待费45512.572051.366014.33183578.1393302.48151415.72193868.01438586.21330771.03461797.07516914.181309482.28第四季第四季汇总总计第一季第一季汇总第二季第二季汇总第三季第三季汇总年份2010年份2010产品规格销售数量销售额用户名称销售数量SX-D-128163009000四川省6SX-D-192163028000新疆3SX-D-256143213000总计9总计469250000年份2010年份2010求和项:销售额用户名称用户名称销售数量销售人员广东省广西省广东省1侯士杰180000822000广西省20李立新562000总计21王心刚944000杨则力722000总计1800003050000方法：第一步：先在同一表中建立多个不同的透视表，选定任意透视表，插入“年份”字段的切片器；第二步：“切片器工具”——“选项”——单击“数据透视表连接”按钮；第三步：勾选要连接的透视表。销售额13520007500002102000销售额18000030500003230000年份200820092010年份用户名称销货单号销售人员产品规格出库单号2008山西省X3708-001王心刚SX-D-25605862008天津市X3708-002侯士杰SX-D-25605852008广东省X3708-003李立新SX-D-25605902008云南省X3708-004杨则力SX-D-19219072008内蒙古X3708-005王心刚SX-D-25600102008四川省X3708-006侯士杰SX-D-12805962008四川省X3708-007李立新SX-D-25605972008四川省X3708-007更换杨则力SX-D-25600162008四川省X3708-008王心刚SX-D-12805982008宁夏X3708-009侯士杰SX-D-12805882008新疆X3708-010李立新SX-D-12805992008内蒙古X3708-011杨则力SX-D-12806002008内蒙古X3708-012王心刚SX-D-12800152008内蒙古X3708-013侯士杰SX-D-12805922008四川省X3708-014李立新SX-D-12805932008四川省X3708-015杨则力SX-D-12805942008四川省X3708-016王心刚SX-D-12805952008黑龙江省X3708-017侯士杰SX-D-25600062008广东省X3708-018李立新SX-D-12800032008辽宁省X3708-019杨则力SX-D-12819192008辽宁省X3708-020王心刚SX-D-12800112008浙江省X3708-021侯士杰SX-D-12805872008云南省X3708-022李立新SX-D-19200072008天津市X3708-023杨则力SX-D-19200052008天津市X3708-024王心刚SX-D-19200042008江西省X3708-025侯士杰SX-D-12800132008江西省X3708-026李立新SX-D-12800122008江西省X3708-027杨则力SX-D-12800142008内蒙古X3708-028王心刚SX-D-12800082008内蒙古X3708-028侯士杰SX-D-12800082008河北省X3708-029李立新SX-D-12800172008辽宁省X3708-030杨则力SX-D-12800192008内蒙古X3708-031王心刚SX-D-12800202008内蒙古X3708-032侯士杰SX-D-12815412008内蒙古X3708-033李立新SX-D-19215422008黑龙江省X3708-034杨则力SX-D-25615452008四川省X3708-035王心刚SX-D-12815512008江苏省X3708-036侯士杰SX-D-25615522008湖南省X3708-037李立新SX-D-19215552008湖北省X3708-038杨则力SX-D-19215542008黑龙江省X3708-039王心刚SX-D-25615562008广西省X3708-040侯士杰SX-D-19206712008内蒙古X3708-041李立新SX-D-12819012008内蒙古X3708-041杨则力SX-D-12819012008内蒙古X3708-042王心刚SX-D-12815602008内蒙古X3708-043侯士杰SX-D-12819112008内蒙古X3708-044李立新SX-D-12819032008内蒙古X3708-045杨则力SX-D-19215582008四川省X3708-046王心刚SX-D-19215572008吉林省X3708-047侯士杰SX-D-12819042008四川省X3708-048李立新SX-D-12819022008广东省X3708-049杨则力SX-D-12819092008甘肃省X3708-050王心刚SX-D-12819182008天津市X3708-051侯士杰SX-D-19219082008内蒙古X3708-052李立新SX-D-12819132008广东省X3708-053杨则力SX-D-25606612008浙江省X3708-054王心刚SX-D-25619142008江西省X3708-055侯士杰SX-D-12819102008广东省X3708-056李立新SX-D-19219152008山东省X3708-057杨则力SX-D-19219162008内蒙古X3708-058王心刚SX-D-12819122008内蒙古X3708-059侯士杰SX-D-12819122008江苏省X3708-060李立新SX-D-25619222008宁夏X3708-061杨则力SX-D-19215442008浙江省X3708-062王心刚SX-D-19219172008浙江省X3708-063侯士杰SX-D-25619202008广东省X3708-064李立新SX-D-25606652008浙江省X3708-065杨则力SX-D-25606662008黑龙江省X3708-066王心刚SX-D-25606622008四川省X3708-067侯士杰SX-D-19206702008新疆X3708-068李立新SX-D-19206672008新疆X3708-069杨则力SX-D-19206682008四川省X3708-070王心刚SX-D-19219272008湖北省X3708-071侯士杰SX-D-25606722008江西省X3708-072李立新SX-D-19206732008宁夏X3708-073杨则力SX-D-12819052008宁夏X3708-074王心刚SX-D-12815462009天津市X3709-001侯士杰SX-D-19206742009天津市X3709-001李立新SX-D-19206742009四川省X3709-002杨则力SX-D-12806752009湖南省X3709-003王心刚SX-D-19206762009江西省X3709-004侯士杰SX-D-19206772009浙江省X3709-005李立新SX-D-19206792009广东省X3709-006杨则力SX-D-12806782009广东省X3709-007王心刚SX-D-19206812009广东省X3709-008侯士杰SX-D-19206822009广东省X3709-009李立新SX-D-19206882009广东省X3709-010杨则力SX-D-19206892009陕西省X3709-011王心刚SX-D-19206802009陕西省X3709-011侯士杰SX-D-19206802009陕西省X3709-012李立新SX-D-19206852009陕西省X3709-012杨则力SX-D-19215252009陕西省X3709-013王心刚SX-D-19215222009四川省X3709-014侯士杰SX-D-19215232009湖北省X3709-015李立新SX-D-25615242009宁夏X3709-016杨则力SX-D-19206832009新疆X3709-017王心刚SX-D-19219292009新疆X3709-018侯士杰SX-D-19219302009新疆X3709-019李立新SX-D-19219312009新疆X3709-019杨则力SX-D-19219312009新疆X3709-019王心刚SX-D-19219312009新疆X3709-019侯士杰SX-D-19219312009新疆X3709-019李立新SX-D-19219312009新疆X3709-020杨则力SX-D-12819322009新疆X3709-020王心刚SX-D-25619322009山东省X3709-021侯士杰SX-D-25606902009陕西省X3709-022李立新SX-D-19215262009四川省X3709-023杨则力SX-D-19215272009宁夏X3709-024王心刚SX-D-19215292009河北省X3709-025侯士杰SX-D-12815302009福建省X3709-026李立新SX-D-12815282009内蒙古X3709-027杨则力SX-D-19215312009湖北省X3709-028王心刚SX-D-19219332009宁夏X3709-029侯士杰SX-D-12819282009宁夏X3709-030李立新SX-D-19219352009山东省X3709-031杨则力SX-D-25619342009广东省X3709-032王心刚SX-D-25615322009广东省X3709-032侯士杰SX-D-25615322009广东省X3709-032李立新SX-D-25615322009安徽省X3709-034杨则力SX-D-19219362009安徽省X3709-034王心刚SX-D-19219362009广东省X3709-035侯士杰SX-D-19219372009宁夏X3709-03