Collapse All Totals In A Pivot Table In Google Sheet By Google Sheet Api And Python

I created google sheet pivot table through the api in python. But, I am unable to collapse rows with totals. I just cant find solution to do that. I am using batchUpdate function t

Solution 1:

Check for PivotGroupValueMetadata :

collapsed boolean

True if the data corresponding to the value is collapsed.

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/pivot-tables#pivotgroupvaluemetadata

And check :

https://developers.google.com/sheets/api/samples/pivot-tables#edit_pivot_table_columns_and_rows

Collapses the column for each Region, with the exception of "West", hiding the Salesperson group for that region. This is done by setting collapsed to true in the valueMetadata for that column in the Region column group.