This is a migrated thread and some comments may be shown as answers.

Edit cell capability

5 Answers 152 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Chris Fitch
Top achievements
Rank 1
Chris Fitch asked on 24 Oct 2012, 05:03 PM
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?

5 Answers, 1 is accepted

Sort by
0
Tsvetoslav
Telerik team
answered on 26 Oct 2012, 05:33 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Chris Fitch
Top achievements
Rank 1
answered on 26 Oct 2012, 12:29 PM
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.
0
Tsvetoslav
Telerik team
answered on 29 Oct 2012, 02:29 PM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Chris Fitch
Top achievements
Rank 1
answered on 31 Oct 2012, 06:40 PM
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.

0
Tsvetoslav
Telerik team
answered on 01 Nov 2012, 07:59 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
PivotGrid
Asked by
Chris Fitch
Top achievements
Rank 1
Answers by
Tsvetoslav
Telerik team
Chris Fitch
Top achievements
Rank 1
Share this question
or