You Cannot change data inside a pivot table

Desktop editors
1

You Cannot change data inside a pivot table

2

When you click Drill Down in the PivotTable

3

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.

4

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

image
image1131×604 48.7 KB

5

image
image953×370 24 KB

6

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

7

image
image1263×122 13.6 KB

8

Hello @leigong

I’m trying to find a way to do it.
I will update the thread once I get anything.

10

Unfortunately, right now we don’t have any methods for interaction with Pivot Tables.
However, I have added your request to the suggestion 55633 to such possibility.

Please accept my apologies for the inconvenience caused.

12

Thank you very much for your reply

1 Like