https://bugs.documentfoundation.org/show_bug.cgi?id=112867
Roman Kuznetsov <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Status|NEEDINFO |NEW --- Comment #4 from Roman Kuznetsov <[email protected]> --- The problem here was: I couldn't create the filter with a grouping by month/years without going by some strange way. For example you have the source cell range with Date Name Values 12-12-21 Ivan 100 13-12-21 Ivan 200 etc. And you want filter your pivot table by month/year. Your actions here? Just move Date field to Filters area in Pivot table layout dialog, right? Of course! But when you'll try use that filter you'll see all dates day-by-day in filter window instead grouped dates. There is a workaround here. Move Date field to Row fields area and close the dialog. Right click on any cell with date in the pivot table and press F12 key. It opens the Grouping dialog where you'll can select Group by. Select there Months and Years and press OK button. Open the Pivot table layout dialog. Move Years and Date field from Row fields area to Filters. Now, you can filter by years and by months =(. I wanted to have an opportunity do the same with one action -> opening the Grouping dialog for date without any moving of fields in the Pivot table layout dialog -- You are receiving this mail because: You are the assignee for the bug.
