How to resume only higher values?

The “math” part, following this suggestion (with a more precise explanation here), could be solved by adding a field ("Results") to your Answers table with this formula :

Answers.Filter(Group=thisRow.Group).Answer.Sort(False()).Slice(0,2).Sum()

I’m not sure though if it was really what you were looking for (in terms of where to have those results)

But I’ll admit that I couldn’t find a logical way to get those Results as a table :confused: .
(I didn’t have much time to really look at all this, sorry)

2 Likes