计算的字段帮助。获取有数码体重不足卡车的百分比
我正在进行一个项目，我应该只使用枢轴桌子来获得重量低下（25,000磅）的卡车的百分比。我根本不允许触摸或将任何内容添加到数据中。我的数量计算了多少卡车，我只是不知道如何获得总百分比。我无法将任何内容添加到数据中。我唯一的提示是我需要使用计算的字段。
这就是我到目前为止的：这些数据已经过滤，似乎需要做的就是将过滤数据并将其与未经过滤的数据进行分配。请帮忙
I am doing a project and I am supposed to get the percentages of trucks that are under weight (under 25k lbs) by using only a pivot table. I am not allowed to touch or add anything to the data at all. I have the count of how many trucks are under weights, I just do not know how to get the total percentage. I cannot add anything to the data. My only hint was that I need to use calculated field.
This is what I have so far: This data has been filtered and what seems like I need to do is take the filtered data and divide it with the unfiltered data. Please Help
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
在“值字段设置”中，您可以选择如何将值显示为…％的总计
https：//support.microsoft.com/en-us/en-us/office/office/show-different/show-different-calculent-calculation-in-pivue-in-pivuetue -Fields-014D2777-BAAF-480B-A32B-98431F48BFEC
In the “value field settings” you can choose how to show the values as … % of different totals
https://support.microsoft.com/en-us/office/show-different-calculations-in-pivottable-value-fields-014d2777-baaf-480b-a32b-98431f48bfec