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
Show Totals in List on Interface Dashboard
+8Best answer by JulieO
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.
+28Hey! 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"
+8I 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.
+31I 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
+8Thanks 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.
+35I 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
+4I 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
Your solution works perfectly fine! Thank you so much 😉
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.