https://bugs.documentfoundation.org/show_bug.cgi?id=113908
--- Comment #5 from kompilainenn <79045_79...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
