This content has been marked as final. Show 2 replies
I have an issue whereby I have created a sort order 1-7 and applied it to a field, but when the sum of that field is 0, the sort order does not apply.
Below demonstrates the correct sort order (see Tax in position 6).
When a different month is selected and Tax has a 'Actual' result of 0, it is automatically placed at the top of the group list.
How can I maintain this sort order at all times?