[Libreoffice-bugs] [Bug 113908] [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from kompilainenn <79045_79045 at mail.ru> ---
(In reply to Bartosz from comment #4)
> How I could edit filter of grouped date in MS Excel?
> 
> I would like to recreate similar document by ownself.
> How I could create such grouped filter?


0. create table with date in one column and any data in another columns
1. insert pivot table
2. In dialogue Pivot Table Layout: move field "date" from "Available fields" to
"Row fields", another field move to you need. Push "OK"
3. In pivot table right click on any cell with date and press F12 on keyboard.
Opens dialogue "Grouping"
4. Select Intervals (checkbox) "Months" and "Years". Press "OK"
5. On pivot table right click and select from context menu "Edit layout"
6. In dialogue Pivot Table Layout: move fields "date" and "Years" from "Row
fields" to "Page fields", another field move to you need. Push "OK"
7. In top of pivot table must creates two 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/20171125/63efdb4a/attachment.html>