Aggregation based on calculated dimension

[Former Member]

Dear Team,

Would like to create groups based on dimension values. refer below screen print for requirement.

created "CD2" calculated dimension based on "CD1" values as below

Condition for CD2 : IF (( CD =1 or CD=2 or CD =3 ), "Group1", IF((CD =2 or CD =3 or CD =4 ),"Group2"), etc )) .

However when I select Group1 as filter it is not considering all the values from ( CD = 1,2, & 3) and it is only populating "CD1 =3" values for Group1 where as business expecting sum of CD1 values (1 +2 +3 ) for Group1. Above picture depicts expectation and actual result.

From picture would expect 21 instead of 6 when I select group 1 .

Could you please suggest how can i achieve expected result in this case ?

Regards

Sudhakar