Skip to main content

I have a list to show the previous month orders and would like to total the number and currency fields. I do not see any way to show totals in a list on an Interface dashboard. Is this possible?

 

Hey! This is def possible. You will want to use a "Number" interface. For getting a sum of total amount, use "Field Summary" and select the Total License Fees field.
For total count of transactions, you could use "Record Count"


I want to show the totals within the list. I know how to do it with numbers, but I would rather have the list show the totals at the top or bottom.


I want to show the totals within the list. I know how to do it with numbers, but I would rather have the list show the totals at the top or bottom.


I don't think so I'm afraid.  You could try using hierarchies for this?  You'd link each order to a record in another table that represented that month year, and then you'd use rollup / count fields to get the totals

 

 

Link to base


I prefer to use Dashboards when something in the list needs to be summed.


Thanks for the replies.  I guess my options are to add another interface page that is a list or use the number fields in a dashboard. It would be great to be able to show totals in a list within a dashboard.


I agree that this is a much-needed feature. Be sure to submit it as a feature request to support@airtable.com 

- ScottWorld, Expert Airtable Consultant


I don't think so I'm afraid.  You could try using hierarchies for this?  You'd link each order to a record in another table that represented that month year, and then you'd use rollup / count fields to get the totals

 

 

Link to base


Your solution works perfectly fine! Thank you so much 😉


Reply