数据透视表--实例教程一表格文件下载.xls

1、国国家家/地地区区 销销售售人人员员订订单单金金额额订订单单日日期期订订单单 IDID英国Buchanan￥440.007/16/200310248英国Suyama￥1,863.407/10/200310249美国Peacock￥1,552.607/12/200310250美国Leverling￥654.067/15/200310251美国Peacock￥3,597.907/11/200310252美国Leverling￥1,444.807/16/200310253英国Buchanan￥556.627/23/200310254英国Dodsworth￥2,490.507/15/200310255

2、美国Leverling￥517.807/17/200310256美国Peacock￥1,119.907/22/200310257美国Davolio￥1,614.887/23/200310258美国Peacock￥100.807/25/200310259美国Peacock￥1,504.657/29/200310260美国Peacock￥448.007/30/200310261美国Callahan￥584.007/25/200310262英国Dodsworth￥1,873.807/31/200310263英国Suyama￥695.628/23/200310264美国Fuller￥1,176.008

3、/12/200310265美国Leverling￥346.567/31/200310266美国Peacock￥3,536.608/6/200310267美国Callahan￥1,101.208/2/200310268英国Buchanan￥642.208/9/200310269美国Davolio￥1,376.008/2/200310270英国Suyama￥48.008/30/200310271英国Suyama￥1,456.008/6/200310272美国Leverling￥2,037.288/12/200310273英国Suyama￥538.608/16/200310274美国Davolio￥

4、291.848/9/200310275美国Callahan￥420.008/14/200310276美国Fuller￥1,200.808/13/200310277美国Callahan￥1,488.808/16/200310278美国Callahan￥351.008/16/200310279美国Fuller￥613.209/12/200310280美国Peacock￥86.508/21/200310281美国Peacock￥155.408/21/200310282美国Leverling￥1,414.808/23/200310283美国Peacock￥1,170.378/27/200310284美

5、国Davolio￥1,743.368/26/200310285美国Callahan￥3,016.008/30/200310286美国Callahan￥819.008/28/200310287美国Peacock￥80.109/3/200310288英国King￥479.408/28/200310289美国Callahan￥2,169.009/3/200310290英国Suyama￥497.529/4/200310291美国Davolio￥1,296.009/2/200310292美国Davolio￥848.709/11/200310293Microsoft Word Document练习指导美国

6、Peacock￥1,887.609/5/200310294美国Fuller￥121.609/10/200310295英国Suyama￥1,050.609/11/200310296英国Buchanan￥1,420.009/10/200310297英国Suyama￥2,645.009/11/200310298美国Peacock￥349.509/13/200310299美国Fuller￥608.009/18/200310300美国Callahan￥755.009/17/200310301美国Peacock￥2,708.8010/9/200310302英国King￥1,117.809/18/20031

7、0303美国Davolio￥954.409/17/200310304美国Callahan￥3,741.3010/9/200310305美国Davolio￥498.509/23/200310306美国Fuller￥424.009/25/200310307英国King￥88.809/24/200310308美国Leverling￥1,762.0010/23/200310309美国Callahan￥336.009/27/200310310美国Davolio￥268.809/26/200310311美国Fuller￥1,614.8010/3/200310312美国Fuller￥182.4010/4/2

8、00310313美国Davolio￥2,094.3010/4/200310314美国Peacock￥516.8010/3/200310315美国Davolio￥2,835.0010/8/200310316英国Suyama￥288.0010/10/200310317美国Callahan￥240.4010/4/200310318英国King￥1,191.2010/11/200310319英国Buchanan￥516.0010/18/200310320美国Leverling￥144.0010/11/200310321英国King￥112.0010/23/200310322美国Peacock￥164.

9、4010/14/200310323英国Dodsworth￥5,275.7110/10/200310324美国Davolio￥1,497.0010/14/200310325美国Peacock￥982.0010/14/200310326美国Fuller￥1,810.0010/14/200310327美国Peacock￥1,168.0010/17/200310328美国Peacock￥4,578.4310/23/200310329美国Leverling￥1,649.0010/28/200310330英国Dodsworth￥88.5010/21/200310331美国Leverling￥1,786.8

10、810/21/200310332英国Buchanan￥877.2010/25/200310333美国Callahan￥144.8010/28/200310334英国King￥2,036.1610/24/200310335英国King￥285.1210/25/200310336美国Peacock￥2,467.0010/29/200310337美国Peacock￥934.5010/29/200310338美国Fuller￥3,354.0011/4/200310339美国Davolio￥2,436.1811/8/200310340英国King￥352.6011/5/200310341美国Peacoc

11、k￥1,840.6411/4/200310342美国Peacock￥1,584.0011/6/200310343美国Peacock￥2,296.0011/5/200310344美国Fuller￥2,924.8011/11/200310345美国Leverling￥1,618.8811/8/200310346美国Peacock￥814.4211/8/200310347美国Peacock￥363.6011/15/200310348英国King￥141.6011/15/200310349英国Suyama￥642.0612/3/200310350美国Davolio￥5,398.7211/20/2003

12、10351美国Leverling￥136.3011/18/200310352英国King￥8,593.2811/25/200310353美国Callahan￥568.8011/20/200310354英国Suyama￥480.0011/20/200310355英国Suyama￥1,106.4011/27/200310356美国Davolio￥1,167.6812/2/200310357英国Buchanan￥429.4011/27/200310358英国Buchanan￥3,471.6811/26/200310359美国Peacock￥7,390.2012/2/200310360美国Davoli

13、o￥2,046.2412/3/200310361美国Leverling￥1,549.6011/28/200310362美国Peacock￥447.2012/4/200310363美国Davolio￥950.0012/4/200310364美国Leverling￥403.2012/2/200310365美国Callahan￥136.0012/30/200310366英国King￥834.2012/2/200310367美国Fuller￥1,689.7812/2/200310368美国Callahan￥2,390.4012/9/200310369英国Suyama￥1,117.6012/27/200

14、310370美国Davolio￥72.9612/24/200310371英国Buchanan￥9,210.9012/9/200310372美国Peacock￥1,366.4012/11/200310373美国Davolio￥459.0012/9/200310374美国Leverling￥338.0012/9/200310375美国Davolio￥399.0012/13/200310376美国Davolio￥863.6012/13/200310377英国Buchanan￥103.2012/19/200310378美国Fuller￥863.2812/13/200310379美国Callahan￥1

15、,313.821/16/200410380美国Leverling￥112.0012/13/200310381美国Peacock￥2,900.0012/16/200310382美国Callahan￥899.0012/18/200310383美国Leverling￥2,222.4012/20/200310384美国Davolio￥691.2012/23/200310385英国Dodsworth￥166.0012/25/200310386美国Davolio￥1,058.4012/20/200310387美国Fuller￥1,228.8012/20/200310388美国Peacock￥1,832.8

16、012/24/200310389英国Suyama￥2,090.8812/26/200310390美国Leverling￥86.4012/31/200310391美国Fuller￥1,440.001/1/200410392美国Davolio￥2,556.951/3/200410393美国Davolio￥442.001/3/200410394英国Suyama￥2,122.921/3/200410395美国Davolio￥1,903.801/6/200410396英国Buchanan￥716.721/2/200410397美国Fuller￥2,505.601/9/200410398美国Callahan￥1,765.601/8/200410399美国Davolio￥3,063.001/16/200410400美国Davolio￥3,868.601/10/200410401美国Callahan￥2,713.501/10/200410402美国Peacock￥855.011/9/200410403美国Fuller￥1,591.251/8/200410404美国Davolio￥400.001/22/