https://bugs.documentfoundation.org/show_bug.cgi?id=132518
--- Comment #6 from Zayed <[email protected]> --- (In reply to Zayed from comment #4) > I find a workaround for this issue as follows: > 1- edit the pivot table by right click on it and choose Proprieties. > 2- Drag the Date field from Filter section to Row Fields. Then click on OK. > 3- left click on any cells of Date, then from menu bar select "Data ---> > Group and Outline ---> Group". > 4- On the "Group by" section select "Years" only. Then click on "OK" > button. > 5- repeat steps 1 to 2 but now return Date field to the Filter Section. Then > OK button. > > Now you can filter by year in Drop-down filter. one more step, make sure the cells are Date not text. -- You are receiving this mail because: You are the assignee for the bug.
