Hi shong,
Thanks for your reply ,
actually because i need to make the following :-

Column1          Column2            Column3      Column4
Ah                         MC                    2                3
Ah                         MD                    1                3
Am                        MC                    1                1

as you suggested it will solve the problem but the reason that i don't want to Group with column2 is i want to add another column like column4 to count All Grouped by column1 only
so the final result will be
Column3 --> Total Count Grouped by Column1 and Column2
Column4 --> Total Count Grouped by Column1 Only

i hope that my explaination is clear.

Best Regards
Ali

Hi ,
i want to make an Conditional Aggregation like the following example :-

Column1          Column2            Column3
Ah                         MC                    150
Ah                         MC                    130
Am                        MC                    100
Ah                         MD                     55


All i want to do i want to Group by Column1 and Count Column3 if the Column2='MC'
so i need final result like the following


Column1          Column2            Column3
Ah                         MC                    2
Ah                         MD                    1
Am                        MC                    1

hope that my explaination is clear

Thanks
Ali