Order Dates Chronologically in Pivot Tabale

  • I have a Pivot Table that is working great except for the fact that the dates are out of order. It is basically ordering everything by month first, day second and year third. The formatt the date is in is MM/DD/YYYY. What i would like is for it to order everything by Year first, Month second and Day third.


    Thanks for any advise you can give me.

  • Re: Order Dates Chronologically in Pivot Tabale


    One way is to use the Grouping feature - right click the pivot table and selecting Group then select Years Months Days in that order

    There are three types of people in this world.
    Those who can count and those who can't.