Excel数据透视表练习表.xlsx

1、订单号销售日期销售人员地区城市家电品牌单价数量（台）102402009-01-02张三华北北京奥克斯12004102412009-01-03李四华北北京格力13005102422009-01-13钱五华北北京美的12506102432009-01-14赵六华北北京春兰15003102442009-01-25刘琦华北石家庄海尔15005102452009-01-26张锋华北石家庄美的14002102462009-01-07罗伊华南广州格力12003102472009-01-08罗伦华南广州美的20002102482009-01-19汤红华南广州松下21004102492009-01-20王维华南

2、广州奥克斯12002102502009-02-11小花华南厦门格力12002102512009-02-12小米华南厦门美的14004102522009-02-13李明华南厦门格力120011102532009-02-24张虹华南厦门美的20008102542009-02-25王娜西南成都松下21002102552009-02-26刘宇西南成都奥克斯12008102562009-03-07陈笑西南成都格力12004102572009-03-18章晓西南成都松下16009102582009-03-29齐易西南昆明奥克斯13007102592009-03-10汪俊西南昆明志高100010102602

3、009-03-11唐敏西南昆明美的13508102612009-03-12刘琳西南昆明春兰12005102622009-03-23欧良西北兰州松下12003102632009-03-26曹容西北兰州松下15002102642009-04-05蒋艳西北兰州春兰15009102652009-04-06李辉西北兰州海尔150011102662009-04-09刘强西北乌鲁木齐美的140012102672009-04-11龚方西北乌鲁木齐格力12004102682009-04-14张强西北乌鲁木齐美的20003102692009-04-17易路西北乌鲁木齐松下21003102702009-04-23戴

4、兰华中武汉奥克斯12002102712009-04-28肖萧华中武汉格力12004102722009-05-03周娇华中武汉美的14002102732009-05-04周军华中武汉格力12002102742009-05-05谢友华中长沙美的20004102752009-05-12艾琳华中长沙松下210011102762009-05-17王芳华中长沙奥克斯12008102772009-05-18饶伟华东上海格力120014102782009-05-19李乐华东上海奥克斯13004102792009-05-20谢九华东上海志高10002102802009-05-21李二华东上海美的13505102

5、812009-05-26周一华东苏州春兰12004102822009-05-29艾奇华东苏州松下120011102832009-06-04小明华东苏州松下15008102842009-06-05柳琴华东苏州春兰15001102852009-06-06刘琦华北石家庄海尔15008102862009-06-07刘琦华北石家庄美的14003102872009-06-18张锋华北石家庄格力12009102882009-06-19张锋华北石家庄美的20007102892009-06-21张三华北北京松下210010102902009-06-23李四华北北京奥克斯12008102912009-06-24大

6、军东北哈尔滨奥克斯12005102922009-06-25小莉东北哈尔滨格力13003102932009-06-26万西东北哈尔滨美的12504102942009-07-04彤彤东北哈尔滨春兰15005102952009-07-05海利东北沈阳海尔15006102962009-07-06全圈东北沈阳美的14003102972009-07-07泉清东北沈阳美的14015102982009-07-08萧逸华东杭州春兰15006102992009-07-09范伟华东杭州海尔15003103002009-07-14周天华东杭州美的14002103012009-07-18艾红华东杭州格力12004103

7、022009-07-22饶伟华东上海美的20004103032009-08-26李乐华东上海松下21002103042009-08-01谢九华东上海奥克斯12004103052009-08-08李二华东上海格力120011103062009-08-12小花华南厦门美的14008103072009-08-13小米华南厦门格力12003103082009-08-14李明华南厦门美的20003103092009-08-15张虹华南厦门松下210010103102009-08-16张虹华南厦门奥克斯12006103112009-08-27罗伊华南广州格力12004103122009-09-10罗伦华南

8、广州志高10003103132009-09-11汤红华南广州美的13504103142009-09-12王维华南广州春兰12005103152009-09-13罗伊华南广州松下12002103162009-09-14青青东北长春松下15009103172009-09-15小娟东北长春志高14009103182009-09-16李娜东北长春春兰12003103192009-09-17小莉东北哈尔滨奥克斯12005103202009-09-18万西东北哈尔滨格力12008103212009-09-19彤彤东北哈尔滨志高10005103222009-10-13泉清东北沈阳奥克斯12006103232

9、009-10-14龚方西北乌鲁木齐格力12003103242009-10-15张强西北乌鲁木齐志高10004103252009-10-16易路西北乌鲁木齐海尔15002103262009-10-17刘强西北乌鲁木齐海尔14004103272009-10-18曹容西北兰州格力120010103282009-10-19蒋艳西北兰州奥克斯12005103292009-10-20李辉西北兰州格力12008103302009-10-21欧良西北兰州志高10004103312009-11-12王刚西南重庆格力12005103322009-11-15赵军西南重庆格力12017103332009-11-16小

10、李西南重庆奥克斯15004103342009-11-25王娜西南成都奥克斯15017103352009-12-01刘宇西南成都格力14002103362009-12-12陈笑西南成都志高14009103372009-12-23汪俊西南昆明春兰12003103382009-12-26齐易西南昆明奥克斯12005销售额480065007500450075002800360040008400240024005600132001600042009600480014400910010000108006000360030001350016500168004800600063002400480028002400800023100960016800520020006750480013200120001500120004200108001400021000960060003900500075009000420070059000450028004800800042004800132001120036006000210007200480030005400600024001350012600360060009600500072003600400030005600120006000960040006000840760001050728001260036006000