一个组基于另一个组的百分比函数
我在报告中有两个分组级别。 A组可以有整个报告的Percentage()，B组也可以，但我想知道A组B组的Percentage()。即使我编码它，似乎内部组和外部组曾经已经创建了页脚，我无法返回到内部组并设置其值。
示例：
A 组总计 50 名 A 组占报告总数的百分比 = 33% A 组占 B 组总计的百分比 = 33%，但我想要 50%
B 组总计 100 B 组 占报告总数的百分比 = 66%
报告总数 150
I have two grouping levels in a report. Group A can have a Percentage() of the entire report and so can Group B, but I would like to know the Percentage() of Group A of Group B. Even if I code it, it seems like once the inner and outer groups have created their footers, I can't go back to to the inner group and set it's value.
Example:
Group A Total 50
Group A percentage of Report Total = 33%
Group A Percentage of Group B Total = 33% but I want 50%
Group B Total 100
Group B Percentage of Report Total = 66%
Report Total 150
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
必须在数据源中处理这个问题。 Access 2007+ 现在在其分组功能中内置了此功能。
Had to handle this in the datasource. Access 2007+ now has this built in their grouping feature.