Author: Joyce Zhou
In a Form, you can easily sort dimension members and data by column. It would be more complicated to sort the members by the column header. However, one common scenario in which this is useful is reversing the order of time by column.
To reverse the order of months, we'll need to inject some custom MDX into our form. Navigate to the NATIVE MDX tab, and check the box Column.
Then switch to the COLUMN tab, and use the MDX provided below to reverse the order of months. We use the MDX ORDER() function here to display time members by Id in descending order.
DESCENDANTS([Time].[Fiscal Calendar].[All], 10000, LEAVES)