topic Re: Sort Dynamic Columns in Pivot Table in App Development

Sort Dynamic Columns in Pivot Table

arivqlik — Fri, 06 Sep 2019 19:35:42 GMT

I have a report with below format. How to Sort the columns with month and yr.

Re: Sort Dynamic Columns in Pivot Table

sunny_talwar — Fri, 06 Sep 2019 19:47:58 GMT

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.

Re: Sort Dynamic Columns in Pivot Table

arivqlik — Fri, 06 Sep 2019 20:13:11 GMT

It is the date field and i converted to =month(column name) & '-' & Year(column name) format. Columns are not sorting

Re: Sort Dynamic Columns in Pivot Table

sunny_talwar — Mon, 09 Sep 2019 12:50:01 GMT

Instead of creating it like this =month(column name) & '-' & Year(column name), create it like this

Date(MonthStart(column name), 'MMM-YYYY')