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