[libreoffice-documentation] What is data hierarchy in pivot table data field options?

Steve (GMail) stevemfanning.wh at gmail.com
Fri Aug 21 09:31:23 UTC 2020

Hi Celia,

Just for information, anything you attach to your email will be stripped 
off again by this mailing list; we can't see your screenshot.

Nevertheless I fully understand your question. Unfortunately I do not 
recall ever seeing the Hierarchy drop-down on the Data Field Options 
dialog in any state other than grayed. I don't know what circumstances 
might lead to it becoming available - maybe one of the developers could 
have a look at the code to see? (email copied to Developers mailing 

I'll update the source material in the 7.0 Calc Guide if we can find the 


Steve Fanning

------ Original Message ------
From: "Celia Palacios" <celia.palacios at libreoffice.org>
To: documentation at global.libreoffice.org
Sent: 21/08/2020 02:03:17
Subject: [libreoffice-documentation] What is data hierarchy in pivot 
table data field options?

>(I forgot to attach the screenshot in previous message. Here it is.)
>Hi, everybody.
>I a member of the Spanish Documentation team. I am currently helping in translation of Calc Guide to Spanish. I am checking the Pivot Tables chapter, and I also have done my reasearch online (and on other LibreOffice channels) trying to understand a concept:
>What is data hierarchy in pivot tables?
>As I said, working on pivot tables chapter there is an option about hierarchy (Jerarquía) that we do not understand (me and someone else) completely. Attached's the screenshot of Data field options dialog in Spanish.
>The Calc guide uses this explanation, which is kind of a circular concept ;D:
>     Hierarchy. Select the hierarchy to use. The pivot table must be based on external source data that contains data hierarchies.
>This is a question for concept: What is a data hierarchy in this option dialog? And more, when/how do I use it?
>I would very much appreciate your help. Thanks.
>Celia Palacios
>-- Ego sum in porta limine.
>-- To unsubscribe e-mail to: documentation+unsubscribe at global.libreoffice.org
>Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/documentation/
>Privacy Policy: https://www.documentfoundation.org/privacy

More information about the LibreOffice mailing list