销售数据透视表

销售数据汇总表销售区域产品名称销售人员第1季度CPU王茵37,429.18成都主板陈建军6,145.51深圳显示器刘怀安43,697.81广州硬盘贺天平24,926.72北京内存杨海63,510.65上海显示器崔鑫亮62,422.37山东硬盘袁园21,822.99厦门显示器李小珂49,644.66福建第1季度-all-第2季度-all-第3季度-all-第4季度-all-RowLabelsData求和项:第1季度求和项:第2季度北京最大值项:合计24,926.724,559.82硬盘24,926.724,559.82成都192,846.4937,429.1877,284.80CPU192,846.4937,429.1877,284.80王茵220,682.3437,429.1877,284.80福建220,682.3449,644.6679,261.81显示器220,682.3449,644.6679,261.81李小珂221,264.8549,644.6679,261.81广州221,264.8543,697.8142,688.68显示器221,264.8543,697.8142,688.68刘怀安236,431.7343,697.8142,688.68山东236,431.7362,422.3734,486.60显示器236,431.7362,422.3734,486.60崔鑫亮145,180.5362,422.3734,486.60上海145,180.5363,510.651,852.79内存145,180.5363,510.651,852.79杨海235,971.3063,510.651,852.79深圳235,971.306,145.5153,881.39主板235,971.306,145.5153,881.39陈建军173,472.996,145.5153,881.39厦门173,472.9921,822.9957,277.26硬盘173,472.9921,822.9957,277.26116,631.55309,599.89TotalResult116,631.55351,293.15236,431.73总表第2季度第3季度第4季度合计77,284.8043,172.2362,796.13220,682.3453,881.3913,801.0199,645.08173,472.9942,688.6864,275.3585,769.89236,431.734,559.8286,042.0777,317.88192,846.491,852.7987,030.7683,577.10235,971.3034,486.6034,230.8214,040.74145,180.5357,277.2636,505.611,025.69116,631.5579,261.8161,182.6031,175.78221,264.85求和项:第4季度77,317.8877,317.8862,796.1362,796.1362,796.1331,175.7831,175.7831,175.7885,769.8985,769.8985,769.8914,040.7414,040.7414,040.7483,577.1083,577.1083,577.1099,645.0899,645.0899,645.081,025.691,025.69455,348.29