HOW TO calculate sum of the count of one column in enrichment activity in adobe campaign classic

hi all, @akshayanand , @_manoj_kumar_,

I have one requirement where

I have display target like this from recipient table

below is the query condition I have to use....

for this condition I am using enrichment activity

Count (primary key -id) and storing it custom column group by Classification                now at the end I had to diSplay output like this display Target like sum of count  of  Count (primary key) group by Classification -that too row wise,,,please help to how can in achieve the same via enrichment or any other activity in adobe campaign classic........