当前时间： 2026-06-25 11:59:48
分类：办公文件
评论(0)
传说中的Excel多角度汇总,原来如此简单实际工作中，经常需要对一组数据从多个角度进行汇总。以下图为例，是一份员工生产记录，包含各员工每天的配件生产数量。需要计算每名员工的日均产量、最低日产量和最高日产量。
按下图所示，在数据透视表字段列表内分别拖动姓名字段到行区域，将生产数量拖动3次到值区域：右键单击透视表“生产数量”字段的任意单元格，值汇总依据修改为平均值：右键单击“生产数量2”字段任意单元格，值汇总依据修改为最大值：同样的方法，将“生产数量3”字段的值汇总方式修改为最小值。OK，已经快速计算出每名员工的日均产量、最低日产量和最高日产量。如果要继续计算出每个员工的产量占比和产量排名，该如何操作呢？你也试试吧~~
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-28 22:22:00 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/668822.html
- 运行时间 : 0.110706s [ 吞吐率：9.03req/s ] 内存消耗：4,838.88kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=498ad1de1330b0f15e38377aa7fddd39
- CONNECT:[ UseTime:0.000594s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000896s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000349s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000304s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000523s ]
- SELECT * FROM `set` [ RunTime:0.000199s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000574s ]
- SELECT * FROM `article` WHERE `id` = 668822 LIMIT 1 [ RunTime:0.000425s ]
- UPDATE `article` SET `lasttime` = 1782656520 WHERE `id` = 668822 [ RunTime:0.019039s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000419s ]
- SELECT * FROM `article` WHERE `id` < 668822 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
- SELECT * FROM `article` WHERE `id` > 668822 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000355s ]
- SELECT * FROM `article` WHERE `id` < 668822 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000787s ]
- SELECT * FROM `article` WHERE `id` < 668822 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000901s ]
- SELECT * FROM `article` WHERE `id` < 668822 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.004433s ]
0.112382s
夜雨聆风
