Control Member Order on Column Header

By - Updated September 20, 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.