Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
arivqlik
Contributor II
Contributor II

Sort Dynamic Columns in Pivot Table

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

clipboard_image_0.png

3 Replies
sunny_talwar

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.

arivqlik
Contributor II
Contributor II
Author

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

 

sunny_talwar

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

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