Question

很难用词解释...... I m试图在矩阵中计算一组不同数值。我要说的是,我有以下数据通过QQL:

------------------------------------------------
| Group | ParentID | ChildID | ParentProdCount |
|     A |        1 |       1 |               2 |
|     A |        1 |       2 |               2 |
|     A |        1 |       3 |               2 |
|     A |        1 |       4 |               2 |
|     A |        2 |       5 |               3 |
|     A |        2 |       6 |               3 |
|     A |        2 |       7 |               3 |
|     A |        2 |       8 |               3 |
|     B |        3 |       9 |               1 |
|     B |        3 |      10 |               1 |
|     B |        3 |      11 |               1 |
------------------------------------------------

查询中还有其他一些数据,但并不重要。家长教育是专门针对家长教育的。

现在,我在“管理报告设计员”中有一个矩阵,试图计算父母子女(由“小组”组组)的一笔款项。如果我只补充这一表述的话。

=Sum(Fields!ParentProdCount.Value)

I get a result 20 for Group A and 3 for Group B, which is incorrect. The correct values should be 5 for group A and 1 for group B. This wouldn t happen if there wasn t ChildID involved, but I have to use some other child-specific data in the same matrix.

我试图确定飞行情报和安全局(IRST)和SUM(SUM)的总职能,但显然不可能规定放弃职能,即使它们有界定的范围。

我确信,在不必另立问题的情况下,计算有组别的单独款项的方法有些。没有人想到如何这样做?

Answer 1

Ok I通过增加一个ROW_NUMBER(NUMBER)功能,来消除这种局面:

SELECT Group, ParentID, ROW_NUMBER() OVER (PARTITION BY ParentID ORDER BY ChildID ASC) AS Position, ChildID, ParentProdCount FROM Table

之后,我取代SSRS SUM的职能。

=SUM(IIF(Position = 1, ParentProdCount.Value, 0))

Answer 2

安排一个小组,负责家长教育,并对该团体进行总结,

指称:

if group over ParentID =  "ParentIDGroup" 
then 
    column sum of ParentPrdCount = SUM(Fields!ParentProdCount.Value,"ParentIDGroup")

友情链接