This message was posted by a user wishing to remain anonymous

​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
Count          3   
 name id   name
     4                a
      5               b
Count            2
total count value ( 5)
I want get the those count 3+2=5 and
Value should be 5

Thanks for your help
#CognosAnalyticswithWatson

Hi Anonymus,

using the GO-Sales package:

Goal:
- We want to count distinct all product lines and all product types and we want to receive the sum of all distinct occurrences.

Steps:
- Create a three-column list containing three data elements:
1. count(distinct [Product Line]) as "cdProductiLine", using aggregation method "count unique elements"
2. count(distinct [Product Type]) as "csProductType", using aggregation method "count unique elements"
3. [cdProductLine] + [cdProductType] contains the total result, using aggregation method "sum"

Hope it works for you this way!

Best Regards,
Bjarne