Oct 02, 2024 09:07 AM
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?
Solved! Go to Solution.
Oct 03, 2024 06:17 AM
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.
Oct 02, 2024 09:14 AM
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"
Oct 02, 2024 10:05 AM
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.
Oct 02, 2024 07:57 PM
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
Oct 02, 2024 08:12 PM
I prefer to use Dashboards when something in the list needs to be summed.
Oct 03, 2024 06:17 AM
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.
Oct 03, 2024 06:29 AM - edited Oct 03, 2024 06:29 AM
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