Cognos Analytics

I need to create a table grouping on of the data set and by adding data set of another column
This is the base file 
I need the output grouping EKU and adding the Sgn with the conditions applied on SSM .
Where VP = sum of SSM from above table( V+Q+C+W)
          QP= Q+C+W and CP = C+W



------------------------------
MONA KEDIA
------------------------------

#CognosAnalyticswithWatson

Create 3 data items in your query:

1. VP = case when [SSM] in ('V'; 'Q'; 'C'; 'W') then [Sgn] end
2. QP = case when [SSM] in ('Q'; 'C'; 'W') then [Sgn] end
3. CP = case when [SSM] in ('C'; 'W') then [Sgn] end

Set both the detail and summary aggregation properties to Total and drag themm into your list, crosstab, graph,...

------------------------------
Daan Lambrechts
------------------------------

Original Message:
Sent: Tue June 25, 2019 01:44 AM
From: MONA KEDIA
Subject: Crosstab and List Query

I need to create a table grouping on of the data set and by adding data set of another column
This is the base file 
I need the output grouping EKU and adding the Sgn with the conditions applied on SSM .
Where VP = sum of SSM from above table( V+Q+C+W)
          QP= Q+C+W and CP = C+W



------------------------------
MONA KEDIA
------------------------------

#CognosAnalyticswithWatson