DVD - How do I sum a metric column based on another calculated measure column

User_8Y0TY

I am using OBIEE 12c and trying to create a report in the DV. I have merged the data from the BI analytics and database table to calculate the Scoreband value. I have created a custom metric column and calculated Scoreband. I have a another metric column with App Count.

I would like to sum up App Count values based on the Scoreband values

Example

Scoreband(Calculated measure) App count(metric)

10 1

20 1

30 1

40 1

10 1

30 1

50 1

So my results should be

Scoreband Total Counts (New metric)

10 2

20 1

30 2

40 1

50 1

I would appreciate your help.

Thanks