I have Multiple Column and Rows fields.
- Column: Year (i.e 2018, stored as a int (tried DateTime and String also) and Month (i.e April, stored as DateTime)
- Row: Name (i.e. Lee Stevens, stored as String) and Charge Type (i.e. Annual Leave, stored as String)
Now, when i sort ONLY the columns OR row, the results display as they should but when i want to Sort from both it "can't" I guess and gives up.
For example when i sort the Column (Year, Month)
This work perfectly fine, It display the Year(s) (i.e. 2018, 2017, 2016) then the Months in order (I.e. Jan, Feb, March)
But as soon as i introduce the sorting the row also they then stop ordering correctly:
The order becomes: 2017, 2019, 2018. Nov, Dec, April, Jan (they seem to loose there sorting?)