How do I remove Year (annual) sub-aggregations in pivot table for monthly data while keeping year-month ordering?
Solution 1:
You can either:
- Right click any of the grouping fields and select 'Ungroup', like this:
or:
- Remove the Year, Quarter and Month fields, leaving the Date remaining, like this: