I am attempting to create a pivot table from a report that I have but the pivot table is not going in order. I know it is because Here is a sample:
<tbody>
</tbody>
When I pull my pivot table, because I am requesting text (Apr 2016, for instance), it is coming through on the pivot table in alphabetical order, rather than date order. How can I fix that?
Month Submitted | Due Date | Person Requesting |
=TEXT(B2,"MMM YYYY") | ##/##/#### | John, Chris Jamie, or Sam |
This is the formula that is giving me problems | Auto populated in this format | Auto populated with one of the above |
<tbody>
</tbody>
When I pull my pivot table, because I am requesting text (Apr 2016, for instance), it is coming through on the pivot table in alphabetical order, rather than date order. How can I fix that?