Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a report with below format. How to Sort the columns with month and yr.
If Month year is a dual field, sort it numerically in ascending or descending order. If it is not, then I suggest fixing this in the script to make it a dual field and then sort it numerically.
It is the date field and i converted to =month(column name) & '-' & Year(column name) format. Columns are not sorting
Instead of creating it like this =month(column name) & '-' & Year(column name), create it like this
Date(MonthStart(column name), 'MMM-YYYY')