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 !