How to drill down from a pivot table in LibreOffice Calc

Hi,

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


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.

Thanks very much in advance.

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.

Thanks very much !
It is quite easy indeed :slight_smile:
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”