Grouping and Summarizing Unique Values In a Table

Ask for Help
2
  • 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 it is checked)
2 Likes