Hi All,
I have a table "fruit"
fruit quantitiy
apple 1
apple 1
orange 3
orange 2
how could I get the total number of apples 2 and total number of orange "5"?
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.
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