[Libreoffice-ux-advise] [Bug 112867] Add button or context menu for (Un)Grouping in dialogue Pivot Table Layout

[bugzilla-daemon at bugs.documentfoundation.org]

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

Roman Kuznetsov <79045_79045 at mail.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |79045_79045 at mail.ru
             Status|NEEDINFO                    |NEW

--- Comment #4 from Roman Kuznetsov <79045_79045 at mail.ru> ---
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 on the CC list for the bug.