Roll up rows in table chart with similar fields

jrtomici
jrtomici Member
in Charting
image.png

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.


Thanks

Tagged:

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!**

Answers

  • 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!**
  • jrtomici
    jrtomici Member

    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.

  • jrtomici
    jrtomici Member

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

Categories