0

Table View column Totals

I have setup a view of my invoice table grouping records by customer and summing the total invoiced, total paid, and total owed fields.  What I am wanting to do is to have a total row at the bottom totaling the whole view. Is this possible with a view or do I have to setup a specific table to make this work?

3 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    The columns in views are just like columns in tables, so you can click on a column name and then select sum and it will total the column. Is that what you want?

    • Tom_Brooks
    • 1 yr ago
    • Reported - view

    @Fred I have the sum of each value at the customer table, but I was wanting to add a total line at the bottom with the entire table sum per column.

    • Tom_Brooks
    • 1 yr ago
    • Reported - view

    ok, I see what I wanted once I shared the view. Is there a way for the view to not be public? Some of this would need to stay private.

Content aside

  • 1 yr agoLast active
  • 3Replies
  • 140Views
  • 2 Following