title: Pivot Table: How to sort Month column chronologically
body: <p>I want to sort the <code>Month</code> column of my pivot table chronologically. In the reference data, I have the <code>Date</code> column formated as date and the <code>Month</code> column as a date too (using &quot;mmm&quot; format), I get the column sorted, but not grouped (months are repeated for each entry).</p>
  <p>I added a helper column <code>Text Month</code> using the <code>TEXT</code> function (for example for <code>E2=TEXT(A2, &quot;mmm&quot;)</code> to try to overcome it. Now I am getting a unique column for month values, but not order chronologically. I am showing both pivot tables (one using <code>Month</code> and another one using <code>Text Month</code> column for the same data set):</p>
  <p><a href="https://i.stack.imgur.com/l8eqn.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/l8eqn.jpg" alt="Pivot Table sample with Month as column" /></a></p>
  <p>Here is the link to my sample:
  <a href="https://docs.google.com/spreadsheets/d/1If6yur9u86T-ABCJm2NEwhC2y1QgPyHFbv2vHORlZFQ/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1If6yur9u86T-ABCJm2NEwhC2y1QgPyHFbv2vHORlZFQ/edit?usp=sharing</a></p>