No access to group/ungroup dates in Pivot Table filter. Jan-24 and Jan-25 show as Jan only.

Any chance to fix by the following:

1. Check Date Formatting: Ensure that the column with dates is formatted consistently as "Date" in Excel. If the format is inconsistent, Excel might not recognize the dates properly for grouping.
2. Disable Automatic Grouping: In Excel 365, you can disable automatic grouping of dates in Pivot Tables:
• Go to File > Options > Data.
• Under "Data options," check the box for "Disable automatic grouping of Date/Time columns in PivotTables."
• This setting prevents Excel from automatically grouping dates into months, quarters, or years.
3. Manual Grouping: If you want to group dates manually:
• Select the date field in the Pivot Table.
• Go to PivotTable Tools > Analyze > Group > Group Selection.
• In the dialog box, choose the grouping options (e.g., Months and Years).
4. Ungrouping Dates: If dates are already grouped and you want to ungroup them:
• Right-click on the grouped date field in the Pivot Table.
• Select "Ungroup."
5. Filter Settings: If you're using the date field as a filter, Excel might display grouped dates by default. You can try adding the date field to the Rows or Columns area instead, where grouping options are more flexible.