Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
6 years ago

Hi amitchandak 

 

This is the raw data I have in table, then I want to summarise in a tbale to show numbers on each cohort and then combine them into one field

 

Table  Summarised  Outcome
CohortPeople ID Cohort People ID  
Cohort 1100 Cohort 18 Cohort 1- 8
Cohort 1101 Cohort 210 Cohort 2- 10
Cohort 1102 Cohort 34 Cohort 3- 4
Cohort 1103 Cohort 42 Cohort 4- 2
Cohort 1104     
Cohort 1105     
Cohort 1106     
Cohort 1107     
Cohort 2108     
Cohort 2109     
Cohort 2110     
Cohort 2111     
Cohort 2112     
Cohort 2113     
Cohort 2114     
Cohort 2115     
Cohort 2116     
Cohort 2117     
Cohort 2118     
Cohort 3119     
Cohort 3120     
Cohort 3121     
Cohort 3122     
Cohort 4123     
Cohort 4124     
       
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi WJ876400m,

You can use following calculate table formula to create a summary and combined table:

New Table =
SELECTCOLUMNS (
    SUMMARIZE ( 'Table', [Cohort], "C", COUNT ( 'Table'[Cohort] ) ),
    "Output", [Cohort] & "-" & [C]
)

Regards,

Xiaoxin Sheng