Expand my Community achievements bar.

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

Avatar

Level 5

hi all, @AkshayAnand , @_Manoj_Kumar_,

I have one requirement where

I have display target like this from recipient table

Shruti1_0-1740675433603.png

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........

1 Reply

Avatar

Community Advisor

Hello @Shruti1  Can you share the target dimension screenshot? We would be able to help you better with that because sometimes the aggregation can be tricky based on the incoming data.


     Manoj
     Find me on LinkedIn