using a pivot with formatted date as column doesn't sort
We are trying to use a friendly formatted date (MMM dd, yyyy) as the column in a formula. This works fine. However, no matter what is put in the sort by bubble, the columns are sorted in alpha order. If the default date format (yyyy-MM-dd) is used, it sorts fine.
The formula for the column is simply:
formatDate(dateField, "MMM dd, yyyy")
It seems to be a general issue in sorting a formatted date formula. Is there a way to work around this?
As an enhancement, it would be helpful to be able to format the display for rows and columns without the need for a formula.