Grid report group by Month/Week order

[partomas]

I figured out that in Grid report if Month/Week is set as columns - the order of values is "random", as in sample. Does anyone has experience how to set consequenced order of months/weeks?

[lazovic]

Hi partomas,

I cannot reproduce your problem. Could you send a screenshot of your full Grid Report settings? Of course, you can blur personal information.

[partomas]

There are a full screen of my settings.

I need to sort accounts by total revenue, but there are no way to order by "created at" moths. In sample reports ordering by MONTH is available.

[lazovic]

partomas,

If you remove the Order By value from your report, the months should be displayed in the correct order.
We can consider how it works, using the example of Group By not a Month, but a Day with different Order By values.

General settings of the report:



Order By is empty:



Order By SUM: Amount (converted) (ASC):



Order By SUM: Amount (converted) (DESC):