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....
Total Recipient
Brand = MCD
- Classification of Recipient
Count (primary key) group by Classification
/!\ Filter :
Classification recipient not equal to 4 and 5
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........