Breaking out percentages within groups

[jb]

Hello,

I've got data that is structured like the below picture. I created the Placement/Date Concat field and am now looking to create the impression weight field to get % impressions for each creative by Placement/Date Concat. I'm guessing it's some type of group by, but I can't seem to solve it. 

Thanks!

[RodL · Accepted solution]

Yes, you would Group By in a Summarize tool on Placement/Date Concat with a Sum on the Impressions.

That will give you a total for each Placement/Date Concat.

You then Join that back to your original work stream with the Placement/Date Concat as your join key.

That will put the total for that specific Placement/Date Concat on each corresponding record.

Then you just use a Formula tool to calculation the Impression divided by the Total Placement/Date Concat that you got from the Join.

[jb]

Thanks @RodL! That's exactly what I needed