基于枢轴表中的其他列中的Excel中创建一个计算出的枢轴表列？
因此，我在查询表中有一堆行，该行显示了一定时间范围的订单，以及该顺序是否具有“缺陷”。我已经在该表上启动了一个枢轴表，以总结那些白天有缺陷的订单和＃（试图启动P-phart）的订单＃。
有什么方法可以在枢轴表中创建第四列，该列表从两个现有列中计算出有缺陷的百分比（订单/订单计数）的百分比？
So I have a bunch of rows in a query table that shows orders from a certain timeframe and whether that order had a "defect" or not. I have started a pivot table on that table to summarize the # of orders and # of those orders that were defective by day (trying to start a p-chart).
Is there any way to create a 4th column in the pivot table that calculates the percent defective (Orders with Defects/Count of Orders) from the two existing columns?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
当然，
基于此站点，这些步骤是：这些步骤：
，单击“计算 字段命令确保您的名字正确）。
最后一个注意：我相信计算出的字段默认情况下执行添加。我注意到您的第二列是“计数”，我相信计算出的字段将总和该列（在分隔之前）而不是对其进行计数。
Sure,
Based on this site, these are the steps:
Once there give a name to your Calculated Field and set your formula to
Orders with defect / orders(tip: select the fields from the list to make sure you get the names right).One last note: I believe calculated fields perform additions by default.. I noticed your 2nd column is a "count", I believe the calculated field will sum that column (before dividing) instead of counting it.