Edit cell capability

[Chris Fitch]

While many pivot tables are aggregates, there is plenty of usefullness to have the 3-d format of a pivot and still be able to handle if the user would like to update a cell value in the aggregate section. Is there anyway to do this?

[Tsvetoslav]

Hi Samuel,

RadPivotGrid does not support this feature since the very concept of pivot data does not allow for it - you will getting wrong calculations and hence misleading reports.


Regards, Tsvetoslav
the Telerik team

[Chris Fitch]

How does the concept prohibit this? When selecting a cell, you should be able to edit the values behind that cell. I think you would call this 'drilling down'? Anyhow, I still dont see why Telerik Devs have assumed that there would be no good reason to select cells. It's not good practice for the designers to be so restrictive of functionality. It's a grid for goodness sake, it makes sense to allow for cell/row/column 'selection' at the least.

If you ask me, it's better practice to leave the restricting up to the end users, while the devs focus on giving the tools diverse functionality.

[Tsvetoslav]

Hi Samuel,

Pivot grid is used to display results not edit them because those results come as the product of certain calculations. That's what I meant by the concept of pivot tables. If, for example, you need the quarter cost of a given company product for the current year, RadPivotGrid will display the result but what would be the use of editing that result when it is a calculated value not a raw one?


Greetings, Tsvetoslav
the Telerik team

[Chris Fitch]

I think I see what you're saying.
I understand that the cells themselves do not house the 'raw data' but are aggregates. Still, I'm hoping for some way to edit the cells that compose the aggregate.

• Ex.
  Double clicking a cell would pop-up the table of cells that compose the data aggregate. this could be done recursively until you hit 'raw data' in which case a double click would allow you to change that certain cell's value.

I still think there is benefit to selecting even aggregated cells. This way, due to call back functions associated with this sort of functionality, at the very least the end user could devise some sort of edit form, or further desired functionality using the selected value.

Editing aggregated cells data aside, please make a point to bring up the versatility that would come with having single + multi/cell selection (along with the call backs associated with them) in the RadPivotGrid.

[Tsvetoslav]

Hello Samuel,

Thanks for the clarification.

Please, use PITS (public issue tracking system) to make this feature suggestion for RadPivotGrid. You should be able to find the issue tracker from your customer's account.


Regards, Tsvetoslav
the Telerik team