Roll up rows in table chart with similar fields

I have a dataset of brands and corresponding data. I would like to have any rows with the same ID and device to be summed up and in one row. I don't want to use ETL for this because there is another column that distinguishes these rows so they may need to be filtered separately at times.


Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    In Analyzer you can select an aggregation for your Total field and select Sum, this will group all your other columns togethers.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**


  • Hi @GrantSmith thanks for the quick response. Unfortunately the table remains as is even when aggregating the total by sum. I have a pie chart that sums up everything correctly (i.e. Connected TV has 49,585), am I missing something? Appreciate the help.

  • @GrantSmith figured it out, I sorted the table by Total and aggregated through there, thank you