dimoss
Well-Known Member
Hi,
I am searching for a way to get a proper ordering of grouped by fields based on existing field.
I found the following:
https://forum.fabrikar.com/forums/index.php?threads/order-by-sum.49189/#post-257128
It is mentioned that ordering is available for single fields.
In my list there is a field called 'Total' which holds the sum of values per record which is actually the sum of other elements in the same list. Let's say my list is composed by 'Name', 'field1', 'field2', 'field3' 'Total' (where total is the sum of fields 1,2,3). The ordering works fine if apply it on the 'Total' without applying any Group By.
However when I group by 'Name' to present the name with the highest accumulated 'Total' it doesnt work properly.
I don't know if i am doing something wrong or it doesnt work like that or I should prepare another view but any help is appreciated.
I am searching for a way to get a proper ordering of grouped by fields based on existing field.
I found the following:
https://forum.fabrikar.com/forums/index.php?threads/order-by-sum.49189/#post-257128
It is mentioned that ordering is available for single fields.
In my list there is a field called 'Total' which holds the sum of values per record which is actually the sum of other elements in the same list. Let's say my list is composed by 'Name', 'field1', 'field2', 'field3' 'Total' (where total is the sum of fields 1,2,3). The ordering works fine if apply it on the 'Total' without applying any Group By.
However when I group by 'Name' to present the name with the highest accumulated 'Total' it doesnt work properly.
I don't know if i am doing something wrong or it doesnt work like that or I should prepare another view but any help is appreciated.