COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: dwong11229 on 25 Sep 2018 12:56:12 PM

Title: sum of row value in cognos
Post by: dwong11229 on 25 Sep 2018 12:56:12 PM
Hi
I have one data item which store total value(Total count) of distinct count, how I total up all those distinct count in another data item? Lets say

                           name id   name
                             1              x
                              2               y
                                3             z
sub Count(row)          3   
                           name id   name
                                4                a
                                 5               b
Sub Count(row)          2

Sum count value of sub count is  ( 5)


I want get the those count 3+2=5 and
Value should be 5

Thanks for your help