I am trying to sort a report either automatically or using the arrows at the top of the report view but after sorting by 'shots' once it will no longer sort by anything else.

I want to be able to sort by the field 'decimal' so that the user can change the order by changing the value of the row in 'decimal'.

Why is the report not sorting? Other reports are sorting.