Forum Discussion

Brass Contributor

Nov 13, 2024

Pivot Table: Date Filters are not Condensed

In this one random excel workbook I am trying to modify, the dates in the pivot table are not condensed. They are all over the place. Usually, when I create a pivot table, the dates are sub-sectioned...

Survey Error.xlsx34 KB

excel

HansVogelaar

MVP

Nov 13, 2024

Refresh the pivot table. The 2022 part should disappear.

kittenmeants
Brass Contributor
Nov 13, 2024
Yes, that part will disappear. However, when I put the "Survey date" in the filters, the dates do not condense. We work off of fiscal months and years so it's not just "October" or "2024" that I will need to look at. We are also expected to have a larger amount of data than what is shown, which is why I was looking to trouble shoot why the Filter drop down in the pivot table is not in Year > Month> Day selection format. Just a list of dates. (Also thank you!)

This is what I need for this workbook:
- HansVogelaar
  MVP
  Nov 14, 2024
  I'd add slicers based on the Years (Survey Date) and Months (Survey Date) fields:
  - kittenmeants
    Brass Contributor
    Nov 14, 2024
    That will probably be my solution for now. I would just like to know what is causing this workbook to be funky compared to the others... It's driving me crazy not knowing. lol