Ask Your Question

how to drill down from a pivot table in LibreOffice Calc [closed]

asked 2016-11-16 01:41:45 +0200

Wololo gravatar image


I'm looking for the "drill-down" functionality within an existing pivot table in LibreOffice Calc. Does it exist ? If not, is there any workaround ?

I describe this functionality as follows (sorry for the excel screenshots)

  1. the user is in a pivot table, in this example on the value of Region "East" for the StartYr" 2014; He double-clicks on this cell

image description
2. the double-click opens a new sheet within the file and shows the detailed data, which summed up give the value of 15 customers for this region and Year. image description

Thanks very much in advance.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Wololo
close date 2016-11-17 00:52:25.981699

1 Answer

Sort by » oldest newest most voted

answered 2016-11-16 04:01:54 +0200

mark_t gravatar image

Drill down functionality exists in LibreOffice Calc pivot tables if the option is enabled.

From the Pivot Table Layout dialog, expand Options (click on +) and check the box for "Enable drill to details".

Double click the count cell "15" in the example pivot table will open a new worksheet with the details of the 15 customers.

edit flag offensive delete link more


Thanks very much ! It is quite easy indeed :) I am using a French version, and the translation was not obvious understandable to me: "Enable drill to details" > "Activer le rappel des éléments"

Wololo gravatar imageWololo ( 2016-11-17 00:51:51 +0200 )edit

Question Tools

1 follower


Asked: 2016-11-16 01:41:45 +0200

Seen: 617 times

Last updated: Nov 16 '16