Hi there, Dear Members of the Community !
Sorry for this very unclear title but I have no idea anymore how to describe, shortly, what I’m trying to do .
So, in the sample doc below, I’ve got one table
Tests linked to the second table
Ratings by a
Now, what I would like to do would be to create a field like in the
Expected Results which would be a Cumulative
Sum() seems to work too) of the filtered ratings where
Ratings=4 (only those two) in the corresponding rows.
I’ve done that in
Now, what I would like to have is put those field together in a specific order :
- First all the results for
- Second all the results for
Which should look like :
2 and from there having a real consecutive list of numbers :
3 corresponding to
Ratings=4 still in their corresponding rows.
This field would be to create a field I could use to sort the table
I tried to search the Community before asking but as I spent all day on this, I got completely lost and don’t even know what I’m suppose to search or find .
Is this doable ? I don’t see any reasons why not but I could be deeply wrong .
If anyone does have an idea or a solution, like always, it will be profoundly appreciated !