Hello
Sorry about the title. Actually, I don't really know how to ask it correctly.
Basically, I want the circled value to be the sum of the above 'Max' values. In this case, I expect 500 + 100 = 600.
Is there any alternative to achieve that since I cannot switch the function to SUM; otherwise, the MAX would be lost...
I goal is to show that sum "600" somewhere.
Thanks
Hi @blueliagain , welcome to the community! 🙂
More of a workaround, but if you're using a record field (or you can switch to that), you can display this as the sum of a separate column like this:
1) Add a rollup in the Groups table with Max / Count
2) Add a lookup field for this rollup in your original table
3) This new field's sum will now display the sum of maxes by category.
This is how to build:
Or you can display this value, a little bit simpler, in the Groups table if that works for you:
Not a perfect solution, but I hope it helps 🙂 Here is the base I used for the demonstration.
-- Best, Milan - Automable.AI Free Airtable consultation
