0

How to add a row with totals?

Hello! Does anyone know how to add a row to a table to show the totals of a column? 

Thanks!

4 comments

  • 0
    Avatar
    Claire Jones

    Hi Jennifer,

    Thanks for reaching out!

    You can add results rows to your table that would appear at the bottom of any column to sum the values of the column. 

    To do this you would:

    1. Select the Column component to which you want to add a results row.
    2. Open the Properties panel.
    3. Select one of the function options from the Results Row menu. In your case, you would choose Sum.
      A results row with your total will be added to your column.
    4. Click Save.

    You can find more information about this here.

    Hope this helps!

    If you have any further questions or require support for this, please log a ticket with our team and we'd be happy to help further! 

     

    Claire

  • 0
    Avatar
    Jennifer Pascon

    Thanks Claire! That is not working though :( Is there a missing step?

  • 0
    Avatar
    Claire Jones

    Hi Jennifer,

    I'm not sure why this is not working for you, our support team may need to take a closer look into your specific use case.

    The other way you can see the total for your column is to select Custom from the Results Row drop-down. A Results component would be added to your component where you can insert a SUM function and use results reference of the column you want to sum:

     

    Hope this option works for you! If not and you have any further questions or require support for this, please log a ticket with our team here and we'd be happy to help further! 

     

    Claire

  • 0
    Avatar
    Jennifer Pascon

    It worked like a charm :) thank you!

Please sign in to leave a comment.