Forum Discussion
Date Formatting in pivot table
No, data is already there.
When I select that column (date format) in either Filter or column or row, pivot table doesn't look like it recognizes that column in date format, and treat it like a text.
When date data is treated as a date, pivot table shows it as hierarchy format, year, then month, then day, which can be expanded to show what's below and contracted to only show year or month.
So, one click will let me select or deselect the entire month or year.
Hope this makes sense.
Date format is a format, not the value represents the year or month value. The value is still the date value.
Hope this makes sense.
But, sometimes that's what I see from pivot table with date format. Actually majority of cases I work with.
Pivot table has the ability to group and build hierarchy structure with dates, so it's easier to control the data.
So, there is no way that I could control and change?