Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

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 list)

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


Steve Fanning

------ Original Message ------
From: "Celia Palacios" <>
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:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.