Grouping and Summarizing Unique Values In a Table

I’m building an internal application and we’re running into an issue regarding grouping and summarizing data within a table.

Goal: Per the image below we need to group unqiue values and then sum their corresponding data values from this table below without creating more tables. An Example:

We need to display Lamar as a single Lamar with it’s sum of Impressions, Or Display Chicago as a single Chicago with it’s sum of media cost.

Lamar - (Sum of Impressions across the entire table)
Adxcelerant - (Sum of Impressions across the entire table)

We don’t want to create another table since the data changes daily and new publishers or cities are added.

Thanks in advance for your help!

  • 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

Hey Darren! Thanks for your quick resonse. I applied it and it works perfectly!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.