EXCEL数据透视表练习文件

销售日期销售区域销售员销售商品销售金额￥销售提成￥2017-02-15上海陆思洁电烤箱894884027.02017-02-15大连董珊电烤箱679153056.22017-04-15上海陆思洁电烤箱631212840.42017-01-01大连董珊电烤箱591262660.72017-04-15广州李兵电烤箱479402157.32017-03-15杭州徐逸凡微波炉380001330.02017-02-15广州郑青青微波炉345001207.52017-02-15青岛韩幼娘微波炉345001207.52017-05-01广州李兵电烤箱343571546.12017-03-15大连董珊电烤箱335581510.12017-04-15青岛杨泉电烤箱335581510.12017-01-01青岛杨泉电烤箱327591474.22017-03-15广州李小明微波炉325001137.52017-02-15广州李兵电烤箱271661222.52017-03-15广州李兵电烤箱239701078.72017-02-15杭州徐逸凡微波炉19500682.52017-02-15上海陆思洁微波炉18000630.02017-02-15杭州徐逸凡豆浆机16468411.72017-02-15广州李小明微波炉13600408.02017-03-15上海陆思洁电烤箱13583611.22017-01-01广州郑青青微波炉13500472.52017-01-01大连董珊豆浆机12172304.32017-03-15广州郑青青微波炉12000420.02017-03-15上海陆思洁微波炉12000420.02017-02-15青岛杨泉电烤箱11186503.42017-01-01杭州徐逸凡微波炉11000385.02017-03-15青岛韩幼娘豆浆机10740268.52017-01-01广州张军电磁炉9702194.02017-02-15广州李小明豆浆机9666241.72017-04-15杭州徐逸凡电烤箱9588431.52017-04-15大连董珊微波炉9500332.52017-04-30大连董珊微波炉9500332.52017-01-01广州张军豆浆机9487237.22017-04-15青岛韩幼娘电磁炉9009180.22017-02-15大连董珊微波炉9000270.02017-02-15广州张军豆浆机8413210.32017-01-01杭州徐逸凡豆浆机8055201.42017-03-15杭州徐逸凡电烤箱7990359.62017-01-01广州郑青青豆浆机7697192.42017-01-01广州李小明电磁炉7623152.52017-03-15广州张军电磁炉7524150.52017-01-01杭州徐逸凡电磁炉7524150.52017-01-01广州李小明豆浆机7339183.52017-01-01大连董珊电磁炉7029140.62017-03-15上海陆思洁电磁炉7029140.62017-01-01广州张军微波炉7000210.02017-02-15大连董珊电磁炉6633132.72017-03-15大连董珊微波炉6400192.02017-02-15广州郑青青豆浆机6086152.22017-01-01大连董珊微波炉5600168.02017-04-15广州郑青青微波炉5600168.02017-04-30广州李兵电烤箱5593251.72017-03-15杭州徐逸凡电磁炉5247104.92017-02-15广州李小明电磁炉5148103.02017-03-15青岛韩幼娘电磁炉5148103.02017-02-15广州张军电磁炉485197.02017-02-15杭州徐逸凡电磁炉485197.02017-02-15青岛韩幼娘豆浆机4833120.82017-03-15青岛杨泉电磁炉435687.12017-03-15杭州徐逸凡豆浆机4296107.42017-02-15上海陆思洁电磁炉415883.22017-01-01广州李小明微波炉4000120.02017-03-15广州李小明电磁炉396079.22017-04-15广州张军电磁炉326765.32017-02-15大连董珊豆浆机322280.62017-03-15大连董珊电磁炉287157.42017-04-15杭州徐逸凡微波炉260078.02017-05-01广州李兵微波炉250087.52017-04-30广州郑青青微波炉240072.02017-03-15青岛杨泉电烤箱2397107.92017-04-15杭州徐逸凡电磁炉237647.52017-04-15杭州徐逸凡豆浆机161140.32017-04-15上海陆思洁电磁炉148529.72017-04-30青岛韩幼娘电磁炉138627.72017-03-15广州张军豆浆机1794.52017-03-15上海陆思洁豆浆机1794.5要求1问题：广州区域销售员李小明电磁炉的销售金额和销售提成将得到的数据填入下表销售商品销售员销售金额￥销售提成￥李小明??问题：广州区域销售员李小明电磁炉的销售金额和销售提成电磁炉销售日期销售区域销售员销售商品销售金额￥销售提成￥2017-02-15上海陆思洁电烤箱894884027.02017-02-15大连董珊电烤箱679153056.22017-04-15上海陆思洁电烤箱631212840.42017-01-01大连董珊电烤箱591262660.72017-04-15广州李兵电烤箱479402157.32017-03-15杭州徐逸凡微波炉380001330.02017-02-15广州郑青青微波炉345001207.52017-02-15青岛韩幼娘微波炉345001207.52017-05-01广州李兵电烤箱343571546.12017-03-15大连董珊电烤箱335581510.12017-04-15青岛杨泉电烤箱335581510.12017-01-01青岛杨泉电烤箱327591474.22017-03-15广州李小明微波炉325001137.52017-02-15广州李兵电烤箱271661222.52017-03-15广州李兵电烤箱239701078.72017-02-15杭州徐逸凡微波炉19500682.52017-02-15上海陆思洁微波炉18000630.02017-02-15杭州徐逸凡豆浆机16468411.72017-02-15广州李小明微波炉13600408.02017-03-15上海陆思洁电烤箱13583611.22017-01-01广州郑青青微波炉13500472.52017-01-01大连董珊豆浆机12172304.32017-03-15广州郑青青微波炉12000420.02017-03-15上海陆思洁微波炉12000420.02017-02-15青岛杨泉电烤箱11186503.42017-01-01杭州徐逸凡微波炉11000385.02017-03-15青岛韩幼娘豆浆机10740268.52017-01-01广州张军电磁炉9702194.02017-02-15广州李小明豆浆机9666241.72017-04-15杭州徐逸凡电烤箱9588431.52017-04-15大连董珊微波炉9500332.52017-04-30大连董珊微波炉9500332.52017-01-01广州张军豆浆机9487237.22017-04-15青岛韩幼娘电磁炉9009180.22017-02-15大连董珊微波炉9000270.02017-02-15广州张军豆浆机8413210.32017-01-01杭州徐逸凡豆浆机8055201.42017-03-15杭州徐逸凡电烤箱7990359.62017-01-01广州郑青青豆浆机7697192.42017-01-01广州李小明电磁炉7623152.52017-03-15广州张军电磁炉7524150.52017-01-01杭州徐逸凡电磁炉7524150.52017-01-01广州李小明豆浆机7339183.52017-01-01大连董珊电磁炉7029140.62017-03-15上海陆思洁电磁炉7029140.62017-01-01广州张军微波炉7000210.02017-02-15大连董珊电磁炉6633132.72017-03-15大连董珊微波炉6400192.02017-02-15广州郑青青豆浆机6086152.22017-01-01大连董珊微波炉5600168.02017-04-15广州郑青青微波炉5600168.02017-04-30广州李兵电烤箱5593251.72017-03-15杭州徐逸凡电磁炉5247104.92017-02-15广州李小明电磁炉5148103.02017-03-15青岛韩幼娘电磁炉5148103.02017-02-15广州张军电磁炉485197.02017-02-15杭州徐逸凡电磁炉485197.02017-02-15青岛韩幼娘豆浆机4833120.82017-03-15青岛杨泉电磁炉435687.12017-03-15杭州徐逸凡豆浆机4296107.42017-02-15上海陆思洁电磁炉415883.22017-01-01广州李小明微波炉4000120.02017-03-15广州李小明电磁炉396079.22017-04-15广州张军电磁炉326765.32017-02-15大连董珊豆浆机322280.62017-03-15大连董珊电磁炉287157.42017-04-15杭州徐逸凡微波炉260078.02017-05-01广州李兵微波炉250087.52017-04-30广州郑青青微波炉240072.02017-03-15青岛杨泉电烤箱2397107.92017-04-15杭州徐逸凡电磁炉237647.52017-04-15杭州徐逸凡豆浆机161140.32017-04-15上海陆思洁电磁炉148529.72017-04-30青岛韩幼娘电磁炉138627.72017-03-15广州张军豆浆机1794.52017-03-15上海陆思洁豆浆机1794.5销售员李小明需一份其电磁炉的销售金额和销售提成的汇总表要求1数据透视表完成后效果如下要求2透视表位置L17要求3对行和列禁用总计销售日期销售区域销售员销售商品销售金额￥销售提成￥2017-02-15上海陆思洁电烤箱894884027.02017-02-15大连董珊电烤箱679153056.22017-04-15上海陆思洁电烤箱631212840.42017-01-01大连董珊电烤箱591262660.72017-04-15广州李兵电烤箱479402157.32017-03-15杭州徐逸凡微波炉380001330.02017-02-15广州郑青青微波炉345001207.52017-02-15青岛韩幼娘微波炉345001207.52017-05-01广州李兵电烤箱343571546.12017-03-15大连董珊电烤箱335581510.12017-04-15青岛杨泉电烤箱335581510.12017-01-01青岛杨泉电烤箱327591474.22017-03-15广州李小明微波炉325001137.52017-02-15广州李兵电烤箱271661222.52017-03-15广州李兵电烤箱239701078.72017-02-15杭州徐逸凡微波炉19500682.52017-02-15上海陆思洁微波炉18000630.02017-02-15杭州徐逸凡豆浆机16468411.72017-02-15广州李小明微波炉13600408.02017-03-15上海陆思洁电烤箱13583611.22017-01-01广州郑青青微波炉13500472.52017-01-01大连董珊豆浆机12172304.32017-03-15广州郑青青微波炉12000420.02017-03-15上海陆思洁微波炉12000420.02017-02-15青岛