https://bugs.documentfoundation.org/show_bug.cgi?id=132518
--- Comment #13 from Zayed <[email protected]> --- (In reply to m_a_riosv from comment #11) > As per comment#4 it works because we are putting the group field in the > filter, after creating it on fields of PT. > > How the filter works in the data source has nothing to do with how it works > in the PT. > > In the PT dates as showed as text (aligned at left), not as truly dates, > this is why it needs to create the group. In fact, when you add a date field > to the rows, trying to filter only show dates not the group of years, as in > the filters of data table. > And GETPIVOTDATA() function only works with dates if they are introduced in > the criteria as text. > > So for me not a bug, maybe could be request for enhancement. Agreed—from a technical standpoint, this functions as an enhancement, but from a user experience standpoint, it feels like broken functionality. End users expect data types to behave consistently across Calc. If a field is recognized as a date in the source data and standard AutoFilters, the Pivot Table filter drop-down should offer the same grouping convenience without forcing manual workarounds. Implementing native date-grouping in Pivot Table filters would drastically improve usability. -- You are receiving this mail because: You are the assignee for the bug.
