You Cannot change data inside a pivot table

[leigong]

You Cannot change data inside a pivot table

[leigong]

When you click Drill Down in the PivotTable

[Constantine]

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:

If I misunderstand please clarify.

[leigong]

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

[leigong]

[Constantine]

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