两列的文本值的百分比
我有两张桌子，1个主和大桌，带有行业，地区，国家等领域：
第二个表也包含相同的列，但它是一个小表，显示了小型团队的性能。
我想计算这支小型团队（ABC）行业的渗透百分比，这些小组（ABC）是根据从大桌子手中获取的基本价值计算得出的。
因此，基本上，如果我们说大桌有700行，其中制造业行为300，而小桌子的制造业行行30行，那么小型团队行业的渗透率为10％，所以我想计算渗透率百分比行业明智，区域明智，国家明智等等
I have two tables, 1 Main and large table with fields such as Industry, Area, Country etc:
the second table also contains same columns but it's a small table which shows performance of small team.
I want to calculate penetration percentage of Industry of this small team(abc) calculated from base value taken from large table.
So basically if let us say large table has total 700 rows out of which Manufacturing Industry rows are 300, and small table has manufacturing industry rows 30, so the penetration of small team Industry wise is 10% , so I want to calculate penetration % Industry wise, Area Wise, Country wise etc.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您没有任何切片机或任何东西，则可以通过创建新表来做到这一点。
该表应该具有行业列的区别。还有两列，其中一个是由行业过滤的大桌子的一个国家。另一个是相同的，但是计算小桌子的行。
If you don't have any slicers or anything, you could do this by creating a new table.
That table should have a DISTINCT of the Industry Column. And two columns, one would be a countrows of the large table filtered by the Industry. And the other one would be the same, but counting the rows of the small table.