Pivot Table - Getting Months by Name to Display in Chronological Order

[Jacob2]

Hi -

I have a database for an NGO that provides services to those in need (in this case, food assistance).

For reporting, I have developed a pivot table that shows the number of households that received services each month by household size (one person, 2 person, 3 person, etc.)

This pulls data from a SERVICES DELIVERED table that has for each household the date of the service delivered and the household size.

The team would like to have the chart display the months by their names (may, june, july, etc.), and then the number of services delivered for 1 person, 2 person, 3 person Households.

I have created a text field in the Services Delivered table for the date of the service delivered (8-10-2026 shows up as August).

However, The Pivot Table only allows me to organize these alphabetically, so they are out of chronological order.

Any ideas for how to get it to display chronologically?

Jacob

[StephenChapman]

Hi @Jacob2, below is a little hack I use to sort chart axes, given you can’t sort axes by another field value:

Assuming you have a Date field in your table, you can create a Month text formula field with the following formula:

<span class="month-formatDate({Date},MM)">formatDate({Date},MMMM)</span>

If it is August, it will return as:

<span class="month-08">August</span>

But will be displayed as August after it is rendered with HTML.

This Month field can then be used as the axes:

Hope that helps!