Skip to main content

How to sum values and sort by another field?

  • June 18, 2024
  • 1 reply
  • 13 views
J
Forum|alt.badge.img+1

Hi all,

I have a base table with the transaction history which lists each profile's contribution amount, date, and the fund invested. Each profile is allowed to invest in many funds and can also invest in the same fund multiple times. How do I create a view that would sum the investment total and sort by funds at the same time?

Here is the transaction history table (base):

I created a "List" from Airtable with Level 1 as Funds and Level 2 as Profiles, but I was not able to sum the values from the same profile:

  • As you can see below, there were multiple transactions from the profile that starts with "2...." within the same fund

1 reply

Alexey_Gusev
Forum|alt.badge.img+25

Choose 'Group by' Profile, add second grouping level 'Fund' and do 'Collapse All'. 
Choose type of Summary 'Sum' at the bottom of field.

If you want to have these values as numbers in the table to use, you should add Rollup field in Profiles table

Terms & ConditionsAccessibility statement