|
|
How do you sort and categorize a view based on months in chronological order?
Insert a hidden column just to the left of your month column. Make this column contain a numeric @month type value that will sort correctly, then sort it. The hidden column should be sorted but not categorized, while the visible month column should be categorized.
If you have multiple years to cope with, use
(@Year(TheDate)-1900)*12 + @Month(TheDate)
in the hidden column so that everything sorts nicely, or you can use an extra categorization on @Year to the left of the month.