计算 Tablix 上分组行的差异
我有一个这样的报告结构：
这个报告的输出是这样的。
但我还想要第三个表，其中包含第一周和上周的差异。
有没有办法在SSRS中做到这一点？
I have a report structure like this:
And the output of this report is like this.
But I also want a third table which contains the differences of the first week and the last week.
Is there a way to do this in SSRS?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我从来没有这样做过，但我想如果没有顶级组，您会拥有一张相同的桌子。尽管您可以在没有组的情况下在那里放置一个额外的列并将其称为差异。在数据集属性中按一年中的周排序，然后在数据框中您将看到表达式：
I have never done this but I guess you would have an identical table without the top level group. Though you could place an extra column there without a group and call it differences. In the data set properties sort by week of the year, then in the data box you would have the expression:
如果没有其他答案，我会尝试在查询中进行聚合，因为在涉及单独的表/矩阵、分组和聚合时，SSRS 并不像大多数人希望的那样灵活。如果您需要有关该查询的帮助，请在下面发表评论，我会提供帮助。
If no other answers work, I would just try to do the aggregation in your query because SSRS isn't as flexible as most would like when it comes to separate tables/matrices, grouping and aggregation. If you need help with that query please put a comment below and I'll help out.