Control Member Order on Column Header
By Joyce Zhou - Aug 07, 2017
In a Kepion form, you can sort dimension members and data easily by column. It would be more complicated to sort the members on column header. One common scenario is to reverse the order of time in column.
To reverse the order of months, we will need to customize the column definition in NATIVE MDX.
We use the MDX ORDER() function here to display time members by Id in descending order.