[Libreoffice-bugs] [Bug 132518] PIVOTTABLE: Filter by year in Drop-down filter window doesn't work

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132518

--- Comment #4 from Zayed <zayed.alsaidi at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210218/9d645cdf/attachment-0001.htm>