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)