ONLYOFFICE Docs v7.3 released: enhanced forms, SmartArt, new security settings, Watch Window, and more
ONLYOFFICE Docs v7.3 released

You Cannot change data inside a pivot table

You Cannot change data inside a pivot table

When you click Drill Down in the PivotTable

Hello @leigong

As far as I know, you have to change the data in the cells of a regular table that is bound to Piot table then refresh the Pivot table itself to display these changes:
2023-02-15 11-55-35

If I misunderstand please clarify.

I need to double-click on the grouped data and drill down to the detailed data

Hello @leigong

Pivot Table is the tool that allows you to reorganize the data of your spreadsheet. The overall functionality may differ from regular tables.
Please take a look at the complete guide about Pivot Tables from our official Help Center:
https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/usageinstructions/pivottables.aspx