8 Answers, 1 is accepted
We have plans for implementing the desired functionalities. Unfortunately we could not commit the exact deadline when these functionalities will be included into the RadPivotGrid. However I will forward your requirements to our developers in order to increase the priority of the desired features.
Kind regards,
Radoslav
the Telerik team

Thanks,
VV
Indeed the described feature could be very useful. I am forwarding your requirement to our developers.
Regards,
Radoslav
the Telerik team

We really love the new pivotgrid. Missing a calculated column is the only reason not to use it for our customers yet.

A calculated column/row is defined as a column/row can be created on client side (ajaxified). Think about a client side calculator, it allows you to do any math functions based on the selected column(s)/row(s).
- Market Share is simply percent of total i.e. CurrentColumnValue/Sum(AllColumnValues).
- Lost Sales as we've been running it is Market Share from Last Year * Sum(AllColumnValuesCurrentYear) - CurrentColumnValue
- Beside the two above, the calcutor should have a few basic math functions, such as min, max, avg, med, %, *,/, +, -, etc...
- let say you have the grid below
- Year 2009, 2010, 2011, 2012
Sped 50, 45, 36, 51 - # Crew Member 8, 7, 5, 8
- Year 2009, 2010, 2011, 2012
- and you use the calculator to select max() function and click on the column 2009, 2010, 2011, 2012 and named it as "Max of 4 Year"
- it will add a new column name "Max of 4 Year" so your grid will look like this
-
Year 2009, 2010, 2011, 2012, Max of 4 Year
Sped 50, 45, 36, 51, 51
# Crew Member 8, 7, 5, 8, 8
-
-
Same thing for calculated row, if you have a sum() and I do not select any rows, the you should treat it as a Grand Total. Other wise if you select sum() and give it a name "Sum" and select (#1,#3,#6), then the calculator should add those selected rows and create a new row with the name "Sum" and display the corresponding data.
-
Year 2009, 2010, 2011, 2012
LL#1 1, 4, 5, 6
LL#2 9, 10, 11, 12
LL#3 10, 11, 12, 13
LL#4 11, 12, 13, 14
LL#5 15, 16, 17, 18
LL#6 19, 10, 11, 12
Sum 30, 25, 28, 31
-
- let say you have the grid below
- Also, as the end user, we need to have to ability to move the row up and down and of course, the sort will override this, but when you unsort, if still need to remember the last set position of the rows. Same thing should apply for column as well.
- If you engineers are interesting to see our window tool, you can send me an email and I'm more than happy to show you the tool.


Hi,
How about adding the possibility for the user to save their particular settings for their particular view
of data
when using a RadPivotGrid? Appropriately this could be done in the PivotGrid/Configuration
Panel.
If you do not plan anytime soon to implement this feature, how would I be able to add
a custom attribute/value to this control that would save the configuration settings in a javascript
cookie
which could be read upon their subsequent return?
Thanks,
Gerald
Unfortunately we do not have built –in functionality for saving the RadPivotGrid settings. Currently we are developing infrastructure for persisting controls settings, however it will be available int the next Q1 2013.
If you need further assistance, do not hesitate to contact us again.
Greetings,
Radoslav
the Telerik team