EXCEL數(shù)據(jù)透視表練習(xí)文件

1、銷售日期銷售區(qū)域銷售員銷售商銷售金額銷售提成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大連董珊電烤箱3355

2、81510.12017-04-15青島楊泉電烤箱335581510.12017-01-01青島楊泉電烤箱327591474.22017-03-15廣州李小明微波爐325001137.52017-02-15廣州李兵電烤箱271661222.52017-03-15廣州李兵電烤箱23970107&12017-02-15杭州徐逸凡微波爐19500682.52017-02-15上海陸思潔微波爐18000630.02017-02-15杭州徐逸凡豆?jié){機(jī)16468411.72017-02-15廣州李小明微波爐13600408.02017-03-15上海陸思潔電烤箱13583611.22017-01-01廣州鄭

3、青青微波爐13500472.52017-01-01大連董珊豆?jié){機(jī)12172304.32017-03-15廣州鄭青青微波爐12000420.02017-03-15上海陸思潔微波爐12000420.02017-02-15青島楊泉電烤箱11186503.42017-01-01杭州徐逸凡微波爐11000385.02017-03-15青島韓幼娘豆?jié){機(jī)10740268.52017-01-01廣州張軍電磁爐9702194.02017-02-15廣州李小明豆?jié){機(jī)9666241.72017-04-15杭州徐逸凡電烤箱9588431.52017-04-15大連董珊微波爐9500332.52017-04-30大連董

4、珊微波爐9500332.52017-01-01廣州張軍豆?jié){機(jī)9487237.22017-04-15青島韓幼娘電磁爐9009180.22017-02-15大連董珊微波爐9000270.02017-02-15廣州張軍豆?jié){機(jī)8413210.32017-01-01杭州徐逸凡豆?jié){機(jī)8055201.42017-03-152017-04-302017-04-152017-04-152017-04-152017-03-152017-04-302017-05-012017-04-152017-03-152017-02-152017-04-152017-03-152017-01-012017-02-152017-

5、03-152017-03-152017-02-152017-02-152017-02-152017-03-152017-02-152017-03-152017-04-302017-04-152017-01-012017-02-152017-03-152017-02-152017-01-012017-03-152017-01-012017-01-012017-01-012017-03-152017-01-012017-01-012017-03-15tT汁汁棉誓莎莎杏莎來棉莎誓莎來棉莎來棉亠亞莎棉莎古簾簾古簾卷簾簾簾古簾簾簾簾古簾古簾簾簾簾簾卷簾簾古簾簾簾簾古簾簾簾古卷i詔13CO615i61123239N)O2OIO2gO2CO7322232O3羽O4OO4OICO4243UI64CO33CO51CO5151co510052475U1935gO5gO65664O66337OO797973397OI247U124762376977O452772JD7吉3475O0075OOI74ga6532co320071烏OO18O18O1O92CH716COO1O1S21篙O1器723O1O61O61CO351g51