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 `LookUp`

Field.

Now, what I would like to do would be to create a field like in the `Expected Results`

which would be a Cumulative `Count()`

(`Sum()`

seems to work too) of the filtered ratings where `Ratings=5`

and `Ratings=4`

(only those two) in the corresponding rows.

I’ve done that in `R=5`

and `R=4`

separately.

Now, what I would like to have is put those field together in a specific order :

- First all the results for
`Ratings=5`

(`1`

,`2`

,`3`

) - Second all the results for
`Ratings=4`

(`1`

,`2`

)

Which should look like : `1`

,`2`

,`3`

,`1`

,`2`

and from there having a real consecutive list of numbers : `1`

,`2`

,`3`

,`4`

,`5`

with `1`

,`2`

,`3`

corresponding to `Ratings=5`

and `4`

,`5`

for `Ratings=4`

still in their corresponding rows.

This field would be to create a field I could use to sort the table `Tests`

.

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 !