<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - PIVOTTABLE: Filter by year in Drop-down filter window doesn't work" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132518#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - PIVOTTABLE: Filter by year in Drop-down filter window doesn't work" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132518">bug 132518</a> from <a class="email" href="mailto:zayed.alsaidi@gmail.com" title="Zayed <zayed.alsaidi@gmail.com>"> Zayed</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>