'Equivalent of .ShowDetail in google apps script

Trying to write a Google apps-script to show details from a pivot table in google sheets.

In vba I would loop through the range of values in the pivot table and use Range(XYZ).ShowDetail = True to create separate sheets of the underlying data - I can right click each value in a pivot in google sheets and select Show Details - I want this done via script.

Any help is much appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source