<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113908#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - [PIVOT TABLE]: filter of grouped date disappears after resaving XLSX file"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113908">bug 113908</a>
from <span class="vcard"><a class="email" href="mailto:79045_79045@mail.ru" title="kompilainenn <79045_79045@mail.ru>"> <span class="fn">kompilainenn</span></a>
</span></b>
<pre>(In reply to Bartosz from <a href="show_bug.cgi?id=113908#c4">comment #4</a>)
<span class="quote">> 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?</span >
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>