Can I calculate sum and display the result?

I want to display the sum of prices with same category.

[ My condition ]
I am creating the wish list for my daily life with glide.
On the list, each item has the data set, for example, category, price, and name.
Categories are like lifestyle, hobby, and foods.

[ What I want to do ]

  1. To calculate the sum of price.
  2. To display the sum of each category’s cost.

Thank you for your cooperation.

You can create a multiple Relation Column that links the category to itself (if it’s the in the same table) or from a category table to the list table. Then create a Rollup Column that uses that relation to sum the prices within that same category.

1 Like