当前位置:文档之家› 数据透视表--实例教程六

数据透视表--实例教程六

数据透视表--实例教程六
数据透视表--实例教程六

国家/地区销售人员订单金额订单日期订单 ID 美国Callahan¥1,313.822004-1-16

美国Fuller¥1,440.002004-1-1

美国Davolio¥2,556.952004-1-3

美国Davolio¥442.002004-1-310394英国Suyama¥2,122.922004-1-310395

美国Davolio¥1,903.802004-1-610396英国Buchanan¥716.722004-1-210397美国Fuller¥2,505.602004-1-910398美国Callahan¥1,765.602004-1-810399美国Davolio¥3,063.002004-1-1610400美国Davolio¥3,868.602004-1-1010401美国Callahan¥2,713.502004-1-1010402美国Peacock¥855.012004-1-910403美国Fuller¥1,591.252004-1-810404美国Davolio¥400.002004-1-2210405英国King¥1,830.782004-1-1310406美国Fuller¥1,194.002004-1-3010407美国Callahan¥1,622.402004-1-1410408美国Leverling¥319.202004-1-1410409美国Leverling¥802.002004-1-1510410英国Dodsworth¥966.802004-1-2110411美国Callahan¥334.802004-1-1510412美国Leverling¥2,123.202004-1-1610413美国Fuller¥224.832004-1-1710414美国Leverling¥102.402004-1-2410415美国Callahan¥720.002004-1-2710416美国Peacock¥11,188.402004-1-2810417美国Peacock¥1,814.802004-1-2410418美国Peacock¥2,097.602004-1-3010419美国Leverling¥1,707.842004-1-2710420美国Callahan¥1,194.272004-1-2710421美国Fuller¥49.802004-1-3110422英国Suyama¥1,020.002004-2-2410423英国King¥9,194.562004-1-2710424英国Suyama¥360.002004-2-1410425美国Peacock¥338.202004-2-610426美国Peacock¥651.002004-3-310427英国King¥192.002004-2-410428美国Leverling¥1,441.372004-2-710429美国Peacock¥4,899.202004-2-310430美国Peacock¥1,892.252004-2-710431美国Leverling¥485.002004-2-710432美国Leverling¥851.202004-3-410433美国Leverling¥321.122004-2-1310434美国Callahan¥631.602004-2-710435美国Leverling¥1,994.522004-2-1110436美国Callahan¥393.002004-2-1210437美国Leverling¥454.002004-2-1410438英国Suyama¥1,078.002004-2-1010439美国Peacock¥4,924.132004-2-2810440Microsoft Word Document

美国Leverling¥1,755.002004-3-1410441美国Leverling¥1,792.002004-2-1810442美国Callahan¥517.442004-2-1410443美国Leverling¥1,031.702004-2-2110444美国Leverling¥174.902004-2-2010445英国Suyama¥246.242004-2-1910446美国Peacock¥914.402004-3-710447美国Peacock¥443.402004-2-2410448美国Leverling¥1,838.202004-2-2710449美国Callahan¥425.122004-3-1110450美国Peacock¥3,849.662004-3-1210451美国Callahan¥2,018.502004-2-2610452美国Davolio¥407.702004-2-2610453美国Peacock¥331.202004-2-2510454美国Callahan¥2,684.002004-3-310455美国Callahan¥557.602004-2-2810456美国Fuller¥1,584.002004-3-310457英国King¥3,891.002004-3-410458美国Peacock¥1,659.202004-2-2810459美国Callahan¥176.102004-3-310460美国Davolio¥1,538.702004-3-510461美国Fuller¥156.002004-3-1810462英国Buchanan¥713.302004-3-610463美国Peacock¥1,609.282004-3-1410464美国Davolio¥2,518.002004-3-1410465美国Peacock¥216.002004-3-1310466美国Callahan¥235.202004-3-1110467美国Leverling¥717.602004-3-1210468美国Davolio¥956.672004-3-1410469美国Peacock¥1,820.802004-3-1410470美国Fuller¥1,328.002004-3-1810471美国Callahan¥1,036.802004-3-1910472美国Davolio¥230.402004-3-2110473英国Buchanan¥1,249.102004-3-2110474英国Dodsworth¥1,505.182004-4-410475美国Callahan¥180.482004-3-2410476英国Buchanan¥558.002004-3-2510477美国Fuller¥471.202004-3-2610478美国Leverling¥10,495.602004-3-2110479英国Suyama¥756.002004-3-2410480美国Callahan¥1,472.002004-3-2510481美国Davolio¥147.002004-4-1010482英国King¥668.802004-4-2510483美国Leverling¥386.202004-4-110484美国Peacock¥1,584.002004-3-3110485美国Davolio¥1,272.002004-4-210486美国Fuller¥889.702004-3-2810487美国Callahan¥1,512.002004-4-210488英国Suyama¥439.202004-4-910489英国King¥3,163.202004-4-310490美国Callahan¥259.502004-4-810491

美国Leverling¥851.202004-4-1110492美国Peacock¥608.402004-4-1010493美国Peacock¥912.002004-4-910494美国Leverling¥278.002004-4-1110495英国King¥190.002004-4-710496英国King¥1,380.602004-4-710497美国Callahan¥575.002004-4-1110498美国Peacock¥1,412.002004-4-1610499英国Suyama¥523.262004-4-1710500英国Dodsworth¥149.002004-4-1610501美国Fuller¥816.302004-4-2910502英国Suyama¥2,048.502004-4-1610503美国Peacock¥1,388.502004-4-1810504美国Leverling¥147.902004-4-2110505英国Dodsworth¥415.802004-5-210506英国King¥749.062004-4-2210507美国Davolio¥240.002004-5-1310508美国Peacock¥136.802004-4-2910509英国Suyama¥4,707.542004-4-2810510美国Peacock¥2,550.002004-4-2110511英国King¥525.302004-4-2410512英国King¥1,942.002004-4-2810513美国Leverling¥8,623.452004-5-1610514美国Fuller¥9,921.302004-5-2310515美国Fuller¥2,381.052004-5-110516美国Leverling¥352.002004-4-2910517美国Peacock¥4,150.052004-5-510518英国Suyama¥2,314.202004-5-110519英国King¥200.002004-5-110520美国Callahan¥225.502004-5-210521美国Peacock¥2,318.242004-5-610522英国King¥2,444.312004-5-3010523美国Davolio¥3,192.652004-5-710524美国Davolio¥818.402004-5-2310525美国Peacock¥1,151.402004-5-1510526英国King¥1,503.002004-5-710527英国Suyama¥392.202004-5-910528英国Buchanan¥946.002004-5-910529美国Leverling¥4,180.002004-5-1210530英国King¥110.002004-5-1910531英国King¥796.352004-5-1210532美国Callahan¥2,222.202004-5-2210533美国Callahan¥465.702004-5-1410534美国Peacock¥1,940.852004-5-2110535美国Leverling¥1,645.002004-6-610536美国Davolio¥1,823.802004-5-1910537英国Dodsworth¥139.802004-5-1610538英国Suyama¥355.502004-5-2310539美国Leverling¥10,191.702004-6-1310540美国Fuller¥1,946.522004-5-2910541美国Davolio¥469.112004-5-2610542

美国Callahan¥1,504.502004-5-2310543美国Peacock¥417.202004-5-3010544美国Callahan¥210.002004-6-2610545美国Davolio¥2,812.002004-5-2710546美国Leverling¥1,792.802004-6-210547美国Leverling¥240.102004-6-210548英国Buchanan¥3,554.272004-5-3010549英国King¥683.302004-6-610550美国Peacock¥1,677.302004-6-610551美国Fuller¥880.502004-6-510552美国Fuller¥1,546.302004-6-310553美国Peacock¥1,728.522004-6-510554英国Suyama¥2,944.402004-6-410555美国Fuller¥835.202004-6-1310556英国Dodsworth¥1,152.502004-6-610557美国Davolio¥2,142.902004-6-1010558英国Suyama¥520.412004-6-1310559美国Callahan¥1,072.422004-6-910560美国Fuller¥2,844.502004-6-910561美国Davolio¥488.702004-6-1210562美国Fuller¥965.002004-6-2410563美国Peacock¥1,234.052004-6-1610564美国Callahan¥639.902004-6-1810565英国Dodsworth¥1,761.002004-6-1810566美国Davolio¥2,519.002004-6-1710567美国Leverling¥155.002004-7-910568英国Buchanan¥890.002004-7-1110569美国Leverling¥2,465.252004-6-1910570美国Callahan¥550.592004-7-410571美国Leverling¥1,501.082004-6-2510572英国King¥2,082.002004-6-2010573美国Peacock¥764.302004-6-3010574英国Buchanan¥2,147.402004-6-3010575美国Leverling¥838.452004-6-3010576英国Dodsworth¥569.002004-6-3010577美国Peacock¥477.002004-7-2510578美国Davolio¥317.752004-7-410579美国Peacock¥1,013.742004-7-110580美国Leverling¥310.002004-7-210581美国Leverling¥330.002004-7-1410582美国Fuller¥2,237.502004-7-410583美国Peacock¥593.752004-7-410584英国King¥142.502004-7-1010585英国Dodsworth¥23.802004-7-910586美国Davolio¥807.382004-7-910587美国Fuller¥3,120.002004-7-1010588美国Callahan¥72.002004-7-1410589美国Peacock¥1,101.002004-7-1410590美国Davolio¥812.502004-7-1610591美国Leverling¥516.462004-7-1610592英国King¥1,994.402004-8-1310593

美国Leverling¥565.502004-7-1610594美国Fuller¥4,725.002004-7-1410595美国Callahan¥1,180.882004-8-1210596英国King¥718.082004-7-1810597美国Davolio¥2,388.502004-7-1810598英国Suyama¥493.002004-7-2110599美国Peacock¥479.802004-7-2110600英国King¥2,285.002004-7-2210601美国Callahan¥48.752004-7-2210602美国Callahan¥1,483.002004-8-810603美国Davolio¥230.852004-7-2910604美国Davolio¥4,109.692004-7-2910605美国Peacock¥1,130.402004-7-3110606英国Buchanan¥6,475.402004-7-2510607美国Peacock¥1,064.002004-8-110608英国King¥424.002004-7-3010609美国Callahan¥299.252004-8-610610英国Suyama¥808.002004-8-110611美国Davolio¥6,375.002004-8-110612美国Peacock¥353.202004-8-110613美国Callahan¥464.002004-8-110614美国Fuller¥120.002004-8-610615美国Davolio¥4,806.992004-8-510616美国Peacock¥1,402.502004-8-410617美国Davolio¥2,697.502004-8-810618美国Leverling¥1,260.002004-8-710619美国Fuller¥57.502004-8-1410620美国Peacock¥758.502004-8-1110621美国Peacock¥560.002004-8-1110622美国Callahan¥1,336.952004-8-1210623美国Peacock¥1,393.242004-8-1910624美国Leverling¥479.752004-8-1410625美国Davolio¥1,503.602004-8-2010626美国Callahan¥1,185.752004-8-2110627美国Peacock¥450.002004-8-2010628美国Peacock¥2,775.052004-8-2010629美国Davolio¥903.602004-8-1910630美国Callahan¥55.802004-8-1510631美国Callahan¥589.002004-8-1910632英国King¥5,510.592004-8-1810633美国Peacock¥4,985.502004-8-2110634美国Callahan¥1,326.222004-8-2110635美国Peacock¥629.502004-8-2610636英国Suyama¥2,761.942004-8-2610637美国Leverling¥2,720.052004-9-110638英国King¥500.002004-8-2710639美国Peacock¥708.752004-8-2810640美国Peacock¥2,054.002004-8-2610641英国King¥696.002004-9-510642英国Suyama¥814.502004-9-210643美国Leverling¥1,371.802004-9-110644

美国Peacock¥1,535.002004-9-210645英国Dodsworth¥1,446.002004-9-310646美国Peacock¥636.002004-9-310647英国Buchanan¥372.372004-9-910648英国Buchanan¥1,434.002004-8-2910649英国Buchanan¥1,779.202004-9-310650美国Callahan¥397.802004-9-1110651美国Peacock¥318.842004-9-810652美国Davolio¥1,083.152004-9-1910653英国Buchanan¥601.832004-9-1110654美国Davolio¥154.402004-9-1110655英国Suyama¥604.212004-9-1010656美国Fuller¥4,371.602004-9-1510657美国Peacock¥4,464.602004-9-810658英国King¥1,227.022004-9-1010659美国Callahan¥1,701.002004-10-1510660英国King¥562.602004-9-1510661美国Leverling¥125.002004-9-1810662美国Fuller¥1,930.402004-10-310663美国Davolio¥1,288.392004-9-1910664美国Davolio¥1,295.002004-9-1710665英国King¥4,666.942004-9-2210666英国King¥1,536.802004-9-1910667美国Davolio¥625.272004-9-2310668美国Fuller¥570.002004-9-2210669美国Peacock¥2,301.752004-9-1810670美国Davolio¥920.102004-9-2410671英国Dodsworth¥3,815.252004-9-2610672美国Fuller¥412.352004-9-1910673美国Peacock¥45.002004-9-3010674英国Buchanan¥1,423.002004-9-2310675美国Fuller¥534.852004-9-2910676美国Davolio¥813.362004-9-2610677英国King¥5,256.502004-10-1610678美国Callahan¥660.002004-9-3010679美国Davolio¥1,261.882004-9-2610680美国Leverling¥1,287.402004-9-3010681美国Leverling¥375.502004-10-110682美国Fuller¥63.002004-10-110683美国Leverling¥1,768.002004-9-3010684美国Peacock¥801.102004-10-310685美国Fuller¥1,404.452004-10-810686英国Dodsworth¥4,960.902004-10-3010687美国Peacock¥3,160.602004-10-710688美国Davolio¥472.502004-10-710689美国Davolio¥862.502004-10-310690美国Fuller¥10,164.802004-10-2210691美国Peacock¥878.002004-10-1310692美国Leverling¥2,071.202004-10-1010693美国Callahan¥4,825.002004-10-910694英国King¥642.002004-10-1410695

美国Callahan¥996.002004-10-1410696美国Leverling¥805.432004-10-1410697美国Peacock¥3,436.452004-10-1710698美国Leverling¥114.002004-10-1310699美国Leverling¥1,638.402004-10-1610700英国Suyama¥2,864.502004-10-1510701美国Peacock¥330.002004-10-2110702英国Suyama¥2,545.002004-10-2010703英国Suyama¥595.502004-11-710704英国Dodsworth¥378.002004-11-1810705美国Callahan¥1,893.002004-10-2110706美国Peacock¥1,641.002004-10-2310707英国Suyama¥180.402004-11-510708美国Davolio¥3,424.002004-11-2010709美国Davolio¥93.502004-10-2310710英国Buchanan¥4,451.702004-10-2910711美国Leverling¥1,233.482004-10-3110712美国Davolio¥2,827.902004-10-2410713英国Buchanan¥2,205.752004-10-2710714美国Leverling¥1,296.002004-10-2910715美国Peacock¥706.002004-10-2710716美国Davolio¥1,270.752004-10-2910717美国Davolio¥3,463.002004-10-2910718美国Callahan¥844.252004-11-510719美国Callahan¥550.002004-11-510720英国Buchanan¥923.872004-10-3110721美国Callahan¥1,570.002004-11-410722美国Leverling¥468.452004-11-2510723美国Callahan¥638.502004-11-510724美国Peacock¥287.802004-11-510725美国Peacock¥655.002004-12-510726美国Fuller¥1,624.502004-12-510727美国Peacock¥1,296.752004-11-1110728美国Callahan¥1,850.002004-11-1410729英国Buchanan¥484.252004-11-1410730英国King¥1,890.502004-11-1410731美国Leverling¥360.002004-11-710732美国Davolio¥1,459.002004-11-1010733美国Fuller¥1,498.352004-11-1210734英国Suyama¥536.402004-11-2110735英国Dodsworth¥997.002004-11-2110736美国Fuller¥139.802004-11-1810737美国Fuller¥52.352004-11-1810738美国Leverling¥240.002004-11-1710739美国Peacock¥1,416.002004-11-2510740美国Peacock¥228.002004-11-1810741美国Leverling¥3,118.002004-11-1810742美国Davolio¥319.202004-11-2110743英国Suyama¥736.002004-11-2410744英国Dodsworth¥4,529.802004-11-2710745美国Davolio¥2,311.702004-11-2110746

英国Suyama¥1,912.852004-11-2610747美国Leverling¥2,196.002004-11-2810748美国Peacock¥1,080.002004-12-1910749英国Dodsworth¥1,590.562004-11-2410750美国Leverling¥1,631.482004-12-310751美国Fuller¥252.002004-11-2810752美国Leverling¥88.002004-11-2710753英国Suyama¥55.202004-11-2710754美国Peacock¥1,948.502004-11-2810755美国Callahan¥1,990.002004-12-210756英国Suyama¥3,082.002004-12-1510757美国Leverling¥1,644.602004-12-410758美国Leverling¥320.002004-12-1210759美国Peacock¥2,917.002004-12-1010760英国Buchanan¥507.002004-12-810761美国Leverling¥4,337.002004-12-910762美国Leverling¥616.002004-12-810763英国Suyama¥2,286.002004-12-810764美国Leverling¥1,515.602004-12-910765美国Peacock¥2,310.002004-12-910766美国Peacock¥28.002004-12-1510767美国Leverling¥1,477.002004-12-1510768美国Leverling¥1,684.272004-12-1210769美国Callahan¥236.252004-12-1710770英国Dodsworth¥344.002004-1-210771美国Leverling¥3,603.222004-12-1910772美国Davolio¥2,030.402004-12-1610773美国Peacock¥868.752004-12-1210774英国King¥228.002004-12-2610775美国Davolio¥6,635.272004-12-1810776美国Leverling¥96.502004-12-2410778美国Fuller¥720.002004-12-2510780美国Fuller¥975.882004-12-1910781英国Dodsworth¥12.502004-12-2210782美国Peacock¥1,442.502004-12-1910783美国Peacock¥1,488.002004-12-2210784美国Davolio¥387.502004-12-2410785美国Callahan¥1,531.082004-12-2310786美国Fuller¥2,622.762004-12-2610787美国Davolio¥3,687.002004-12-3110789英国Suyama¥722.502004-12-2610790美国Davolio¥399.852004-12-3110792美国Peacock¥3,026.852004-12-3110801

相关主题
文本预览
相关文档 最新文档