Some more functionallity wanted

[Alex]

Greetings, 

Yours PivotGrid is awesome, but would you mind to tell me eta on following functionality:

• DrillDown (Recieve a part of datasource which fills the cell value);
• Inline editor

Best Regards, Alex D.

[Radoslav]

Hello Alex,

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

[Vinh]

Also, another nice to have feature that I'm looking forward is the ability to do Calculated Column, which is the ability to do some basic mathematics, statistic functions of the selected columns.

Thanks,

VV

[Radoslav]

Hi Vinh,

Indeed the described feature could be very useful. I am forwarding your requirement to our developers.

Regards,
Radoslav
the Telerik team

[christian]

A calculated column is also on top of my list. If a column shows you a statistic like the ratio of other values, the default aggregate functions don't make sense.

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

[Vinh]

Hi,

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).

1. Market Share is simply percent of total i.e. CurrentColumnValue/Sum(AllColumnValues).
2. Lost Sales as we've been running it is Market Share from Last Year * Sum(AllColumnValuesCurrentYear) - CurrentColumnValue
3. Beside the two above, the calcutor should have a few basic math functions, such as min, max, avg, med, %, *,/, +, -, etc...
   1. let say you have the grid below
      1.                   Year    2009, 2010, 2011, 2012
                          Sped        50,     45,     36,     51
      2. # Crew Member          8,      7,        5,      8
   2. 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"
   3. it will add a new column name "Max of 4 Year" so your grid will look like this

      1.             Year 2009, 2010, 2011, 2012, Max of 4 Year
                        Sped 50,     45,     36,     51,                   51
         # Crew Member 8,       7,      5,        8,                     8

   4. 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. 

      1. 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

1. 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.
2. 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.

 

 

[Chris Fitch]

I too, would very much like to see this functionality.

[Gerald]

Article: http://www.telerik.com/help/aspnet-ajax/pivotgrid-overview.html

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

 

[Radoslav]

Hi 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