HOW TO calculate sum of the count of one column in enrichment activity in adobe campaign classic | Community
Skip to main content
Level 4
February 27, 2025
Question

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

  • February 27, 2025
  • 2 replies
  • 690 views

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

2 replies

Manoj_Kumar
Community Advisor
Community Advisor
March 5, 2025

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  | https://themartech.pro
Sukrity_Wadhwa
Community Manager
Community Manager
April 2, 2025

Hi @shruti1,

Were you able to figure out this problem on your own or do you still need help here? Do let us know.

Thanks!

Sukrity Wadhwa