How do I remove Year (annual) sub-aggregations in pivot table for monthly data while keeping year-month ordering?

Solution 1:

You can either:

  1. Right click any of the grouping fields and select 'Ungroup', like this:

enter image description here

or:

  1. Remove the Year, Quarter and Month fields, leaving the Date remaining, like this:

enter image description here