Unique values to be added to new table

[Darren_Murphy]

You can use the technique described below:

Grouping and Summarizing Unique Values In a Table

Create a multiple relation column that matches the Publisher with itself. Create a rollup column, target it at the multiple relation column, and select Sum->Impressions (or sum->Media Costs) To create something you can use as a filter: Use a single value column to take the first RowID from the multiple relation Create an if-then-else column and apply the following condition: – If RowID is single value RowID, then true Use the if-then-else column as a collection filter (only show rows where …