Announcements
Hi All,
I have a table "fruit"
fruit quantitiy
apple 1
orange 3
orange 2
how could I get the total number of apples 2 and total number of orange "5"?
Hi
I attach sample screenshot.
You can either using fixed formula or using dropdown and many other method.
Hope this helps.
Any method is up to you
You can use the GroupBy function, which will create a new table grouped by the column you need, and then use the AddColumns function and the Sum function to calculate the aggregate value. For example, this expression:
AddColumns( GroupBy(fruit, "fruit", "by_fruit"), "total_quantity", Sum(by_fruit, quantity))
Returns a table with a column "fruit" and a column "total_quantity" which has the information you need.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 525 Most Valuable Professional
Haque 273
Kalathiya 232 Super User 2026 Season 1
