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

Some more functionallity wanted

8 Answers 121 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Alex
Top achievements
Rank 1
Alex asked on 29 Aug 2012, 06:20 AM
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.

8 Answers, 1 is accepted

Sort by
0
Radoslav
Telerik team
answered on 03 Sep 2012, 08:44 AM
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
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
Vinh
Top achievements
Rank 1
answered on 03 Oct 2012, 03:58 PM
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
0
Radoslav
Telerik team
answered on 08 Oct 2012, 05:52 AM
Hi Vinh,

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

Regards,
Radoslav
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
christian
Top achievements
Rank 1
answered on 10 Oct 2012, 08:57 AM
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.
0
Vinh
Top achievements
Rank 1
answered on 10 Oct 2012, 01:51 PM
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.

 

         

0
Chris Fitch
Top achievements
Rank 1
answered on 24 Oct 2012, 03:28 PM
I too, would very much like to see this functionality.
0
Gerald
Top achievements
Rank 1
answered on 29 Oct 2012, 09:01 PM
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

 

0
Radoslav
Telerik team
answered on 01 Nov 2012, 11:04 AM
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
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
Alex
Top achievements
Rank 1
Answers by
Radoslav
Telerik team
Vinh
Top achievements
Rank 1
christian
Top achievements
Rank 1
Chris Fitch
Top achievements
Rank 1
Gerald
Top achievements
Rank 1
Share this question
or