From 327d999641b54d40d8f939a09ab79f37b4a9fc32 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Wed, 26 Aug 2020 12:02:00 -0300 Subject: Clarify use of pivot table data hierarchy After dicussion in documentation mailing list: https://listarchives.libreoffice.org/global/documentation/2020/msg01686.html Change-Id: I86f659ea35b15d6b7032d0ca6c7890c172fc2861 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101409 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/12090106.xhp | 1 + 1 file changed, 1 insertion(+) (limited to 'source') diff --git a/source/text/scalc/01/12090106.xhp b/source/text/scalc/01/12090106.xhp index bd753a949f..4b87101a70 100644 --- a/source/text/scalc/01/12090106.xhp +++ b/source/text/scalc/01/12090106.xhp @@ -65,5 +65,6 @@ Select the items that you want to hide from the calculations. Hierarchy Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies. + Calc does not provide multiple hierarchies for a single field and so this option is normally grayed. If you use a pivot table data source extension, that extension could define multiple hierarchies for some fields and then the option could become available. See the documentation supplied with that extension for more details". -- cgit