OASIS Open Document Format for Office Applications (OpenDocument) TC

Hi members, I'm looking for an example document, which uses the element <table:data-pilot-group>. Notice 'group' in singular, not 'groups'. Or can you tell me, how to generate such document? Kind regards Regina

On 15.09.2017 19:36, Regina Henschel wrote: > Hi members, > > I'm looking for an example document, which uses the element > <table:data-pilot-group>. Notice 'group' in singular, not 'groups'. Or > can you tell me, how to generate such document? i don't know how to create it, but the attachment on this bug uses the element: https://bugs.documentfoundation.org/show_bug.cgi?id=60169 <table:data-pilot-groups table:is-group-field="true" table:source-field-name="Name"> <table:data-pilot-group table:name="Group1"> <table:data-pilot-member table:name="A"/> <table:data-pilot-member table:name="B"/> </table:data-pilot-group> <table:data-pilot-group table:name="Group2"> <table:data-pilot-member table:name="C"/> </table:data-pilot-group> </table:data-pilot-groups> ... so i'm assuming Kohei must know how to create such documents. -- Michael Stahl Software Engineer Platform Engineering - Desktop Team Red Hat Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com Red Hat GmbH, http://www.de.redhat.com/ , Sitz: Grasbrunn, Handelsregister: Amtsgericht München, HRB 153243, Geschäftsführer: Charles Cachera, Michael Cunningham, Michael O'Neill, Eric Shander

Hi Michael, thank you for the pointer to that document. I have managed to create such document now. The essential part is, that the element <table:data-pilot-group> contains the group members directly and therefore makes it possible to group non-numbers. In contrast to grouping a column of numbers you need to select all group members. Example for LibreOffice UI: You have a column of strings labeled "Name" and a column of numbers labeled "Value". Make a Pivot Table with "Name" in Row Fields and "Value" in Data Fields. Mark all names (Ctrl+Click), which you want to be in the same group, and group them by Data > Group and Outline > Group. You get a new column "Name2 with the entry "Group1" for those names, which you had selected. Select the other names from column "Name" (you can use column "Name2" for filtering) and generate the next group the same way. Now the column "Name2" has the entries "Group1" and "Group2". Open "Edit Layout" item from context menu. Find the new field "Name2" in the Row Fields and drag it to the top of Column Fields. OK. Move the cell cursor (arrow keys work better than mouse click) to the new fields. Use the Input line to change the name to a word, which describes your grouping. I hope this helps others who struggle with Pivot Tables like me. Kind regards Regina Michael Stahl schrieb: On 15.09.2017 19:36, Regina Henschel wrote: Hi members, I'm looking for an example document, which uses the element <table:data-pilot-group>. Notice 'group' in singular, not 'groups'. Or can you tell me, how to generate such document? i don't know how to create it, but the attachment on this bug uses the element: https://bugs.documentfoundation.org/show_bug.cgi?id=60169 <table:data-pilot-groups table:is-group-field="true" table:source-field-name="Name"> <table:data-pilot-group table:name="Group1"> <table:data-pilot-member table:name="A"/> <table:data-pilot-member table:name="B"/> </table:data-pilot-group> <table:data-pilot-group table:name="Group2"> <table:data-pilot-member table:name="C"/> </table:data-pilot-group> </table:data-pilot-groups> ... so i'm assuming Kohei must know how to create such documents. Attachment: MyGroupingInPivotTable.ods Description: application/vnd.oasis.opendocument.spreadsheet