|
|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
请问我的透视表内15折扣和14折扣、15VS14的各项比明明是有数据的，可惜汇总的地方却显示#DIV/0!呢？到底错在哪里呢？请各位解答解答，谢谢！
| 行标签 | 广州 | 清远 | 韶关 | 增城 | 肇庆 | 总计 | | 2015 | | | | | | | | 求和项:15收入 | 15897295.5 | 224958.6 | 1838150.4 | 1738695 | 2427482.2 | 22126581.7 | | 求和项:15牌价 | 18065789 | 280298 | 2312419 | 2025866 | 2960479 | 25644851 | | 求和项:15折扣 | 88.00% | 80.26% | 79.49% | 85.82% | 82.00% | 86.28% | | 2014 | | | | | | | | 求和项:14收入 | 23626710.85 | 430743.85 | 3339754 | 4057525.4 | 4694983 | 36149717.1 | | 求和项:14牌价 | 27475580 | 648211 | 4314413 | 5123678 | 5834865 | 43396747 | | 求和项:14折扣 | 85.99% | 66.45% | 77.41% | 79.19% | 80.46% | 83.30% | 求和项:15收入汇总 | 15897295.5 | 224958.6 | 1838150.4 | 1738695 | 2427482.2 | 22126581.7 | | 求和项:15牌价汇总 | 18065789 | 280298 | 2312419 | 2025866 | 2960479 | 25644851 | | 求和项:15折扣汇总 | 88.00% | 80.26% | 79.49% | 85.82% | 82.00% | #DIV/0! | | 求和项:14收入汇总 | 23626710.85 | 430743.85 | 3339754 | 4057525.4 | 4694983 | 36149717.1 | | 求和项:14牌价汇总 | 27475580 | 648211 | 4314413 | 5123678 | 5834865 | 43396747 | | 求和项:14折扣汇总 | 85.99% | 66.45% | 77.41% | 79.19% | 80.46% | #DIV/0! | | 求和项:15VS14牌价比汇总 | -34.25% | -56.76% | -46.40% | -60.46% | -49.26% | #DIV/0! | | 求和项:15VS14收入汇总 | -32.71% | -47.77% | -44.96% | -57.15% | -48.30% | #DIV/0! | 求和项:15VS14折扣汇总 | 2.33% | 20.78% | 2.69% | 8.38% | 1.90% | #DIV/0! |
|
|
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2015-3-8 16:37