I've got one question on how to manage a specific case (I'm not asking for the entire solution, but I'm struggling with how to build the data model - so the basic steps / ideas are highly appreciated )
I have a table - let's say with different people liking different kind of fruits:
In fact the list is much larger by the way...
What I want to know:
I want to create an iterative Top-List, that means in that example:
Top1: Stephan: 3 kind of fruits
Top2: Michael: 1 kind (because for the next one I only want to count the fruits - not included in Top1
I hope this is understandable...
My question is how to manage this - I played with quite a lot possibilities (variable, set expressions) but I can only get to the Top2
Additionally I need the calculation within the app, as (e.g. in this example) I want to exclude banana and recalculate my Top-List.