WILL PIVOT GRID SHOW THE STRING VALUES...?

22 posts, 0 answers
  1. Dhamodharan
    Dhamodharan avatar
    300 posts
    Member since:
    Sep 2010

    Posted 21 Aug 2012 Link to this post

    Hi,
          RadPivotGrid works well to show aggregate values as data...... i have requirement to show the string values in the data fields, to show only the string values as follows

    Category

    Product

    Country

    Beverages

    Chai

    Germany

    Chang

    Usa

    Ipoh Coffee

    Uk

    Sea food

    Rogede sild

    Brazil

    Spegesild

    China

    Ikura

    Uk

    Konbu

    Germany



    Thanks
    Dhamodharan
  2. Milena
    Admin
    Milena avatar
    224 posts

    Posted 23 Aug 2012 Link to this post

    Hello,

    I am not sure that completely understand your requirements, but in case you want to hide the header zones, you can achieve that as use the following properties:

    ShowColumnHeaderZone
    ShowDataHeaderZone
    ShowRowHeaderZone

    If  these properties are set to false all zones will be hidden and only the data cells with their corresponding column header cells and row header cells will be shown.

    Greetings,
    Milena
    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.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Girish
    Girish avatar
    1 posts
    Member since:
    Aug 2012

    Posted 31 Aug 2012 Link to this post

    This a really simple question. How do you display text values in the pivot cells (all examples show numbers)
  5. Milena
    Admin
    Milena avatar
    224 posts

    Posted 03 Sep 2012 Link to this post

    Hello,

    RadPivotGrid is a data summarization control where users can break down raw data in any manner they want. So, each cell can represent several rows. Currently, we are planning to add a filtering functionality to RadPivotGrid, which will give the opportunity to get min, max and  top values and display them in a string format. However, if you do not want to display a summarized data, I would suggest you to use RadGrid and its multi-column headers functionality. In case your recommendations are different, you can demonstrate your goal with pivot table in excel and we will let you know if it is possible to achieve the same result with RadPivotGrid.

    All the best,
    Milena
    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.
  6. Dhamodharan
    Dhamodharan avatar
    300 posts
    Member since:
    Sep 2010

    Posted 04 Sep 2012 Link to this post

    Hi Milena
    I want to display the result in grid as shown below. 

    Category

    Product

    Product

    Beverages

    Chai

    Germany

    Chang

    Usa

    Ipoh Coffee

    Uk

    Sea food

    Rogede sild

    Brazil

    Spegesild

    China

    Ikura

    Uk

    Konbu

    Germany


    Table Details

    Table Name : Product Details

    Product_id

    Product_Category_Id

    Product_category_name

    Product_Name

    Country

     

     

     

     

     

    1

    1

    Bevarages

    Chai

    Germany

    2

    1

    Bevarages

    Chang

    Usa

    3

    1

    Bevarages

    Ipoh Coffee

    UK

    4

    2

    Sea food

    Rogede sild

    Brazil

    5

    2

    Sea food

    Spegesild

    China

    6

    2

    Sea food

    Ikura

    UK

    7

    2

    Sea food

    Konbu

    Germany




    Thanks
    Dhamodharan
  7. Milena
    Admin
    Milena avatar
    224 posts

    Posted 05 Sep 2012 Link to this post

    Hello,

    The data in RadPivotGrid can not be represented in the demonstrated format. RadPivotGrid mimics the behavior of Excel pivot table, where this data presentation is also not possible.

    Greetings,
    Milena
    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.
  8. Martin
    Martin avatar
    19 posts
    Member since:
    Feb 2012

    Posted 03 Oct 2012 Link to this post

    Hello Milena,

    I'm also needing to apply something very similar to what Dhamodharan is asking... if RadPivotGrid does not help, which control can be used in order to get the desired results?

    Regards,
  9. Milena
    Admin
    Milena avatar
    224 posts

    Posted 08 Oct 2012 Link to this post

    Hello,
     
    I would recommend you to review multi-column headers functionality and verify if it meets your requirements. Can you also provide more detailed information about the desired functionality and we will let you know what is the most appropriate control for your scenario?

    Kind regards,
    Milena
    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.
  10. Joel Kraft
    Joel Kraft avatar
    87 posts
    Member since:
    Jan 2004

    Posted 01 Nov 2012 Link to this post

    I guess I'm looking for the answer to the question in the title of the thread.  Does RadPivotGrid support strings for the appropriate aggregates?  COUNT can obviously work with anything, and SUM or AVG would not be appropriate for strings, but MIN and MAX would!

    I have a situation that I've been trying to implement for years, but never got there due to complexity.  In this case, the RPG is absolutely perfect because the situation does rely on a pivot of the original data, but the actual data value is a string.  This is an example of the data:

    Name Section Grade
    Adam First A
    Bart First B
    Cathy First B
    Adam Second A
    Bart Second A
    Cathy Second C
    Cathy Second B

    And here is the output it would expect using Min(Grade):

    First Second
    Adam A A
    Bart B A
    Cathy B B

    The rows and columns work great and it was soooo easy.  The data, though, is just "Error" if I try to use Min or Max.

    Joel
  11. Joel Kraft
    Joel Kraft avatar
    87 posts
    Member since:
    Jan 2004

    Posted 05 Nov 2012 Link to this post

    Nevermind.  I looked at the source and I see right now that Min and Max are explicitly numeric.  Count appears to the the only one that works for non-numeric values.

    Hopefully this can be added in the future, or we can get custom aggregates!
  12. Milena
    Admin
    Milena avatar
    224 posts

    Posted 06 Nov 2012 Link to this post

    Hello,

    I will forward your suggestion to our dev team for further consideration. In case they consider that it is appropriate to add this functionality to RadPivotGrid,I will let you know which of our future releases will contain the improvement.

    Kind regards,
    Milena
    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.
  13. Prabu
    Prabu avatar
    6 posts
    Member since:
    Aug 2013

    Posted 08 Aug 2013 Link to this post

    Hi Telerik Team,

               I need to get the data count separately  which i saved in Aggregate field,Row Fields, Column fields & Filter Fields in Configuration panel Radpivotgrid and save it to my Sql Server DB dynamically. please do the needful as soon as possible.


    Thanks,
    Prabu
  14. Milena
    Admin
    Milena avatar
    224 posts

    Posted 09 Aug 2013 Link to this post

    Hello Prabu,

    On the base of the provided information, I am not completely sure that understand your requirements. Please review the following resources about RadPivotGrid control and see if some of our examples illustrate the desired functionality:

    http://www.telerik.com/help/aspnet-ajax/pivotgrid-overview.html
    http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/configurationpanel/defaultcs.aspx

    Regards,
    Milena
    Telerik
    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 the blog feed now.
  15. Piotr
    Piotr avatar
    1 posts
    Member since:
    Jun 2011

    Posted 17 Oct 2013 Link to this post

    Hello Milena,

    I checked latest release of Telerik components (2013 Q3) and it seems this very important feature is still not implemented, am I right? I hope in nearest feature it will be added cause in many cases it would be extremely useful

    Kind regards,
    Piotr
  16. Milena
    Admin
    Milena avatar
    224 posts

    Posted 21 Oct 2013 Link to this post

    Hello,

    We are planning to include support for calculated Items and Fields in RadPivotGrid from Q1 2014. I hope these features will help you to achieve the desired functionality.

    Regards,
    Milena
    Telerik
    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 the blog feed now.
  17. Rob Anderson
    Rob Anderson avatar
    3 posts
    Member since:
    Sep 2009

    Posted 30 Jul 2014 Link to this post

    I'm looking to place a string value in the PivotGridAggregateField without any calculation similar to what Dhamodharan was requesting at the start of this thread.  I have the latest version of the controls and I still can't make it work.  It should be a simple task for Telerik to incorporate this functionality.  It's very frustrating that it has not been added yet.
  18. Joel Kraft
    Joel Kraft avatar
    87 posts
    Member since:
    Jan 2004

    Posted 31 Jul 2014 in reply to Rob Anderson Link to this post

    I agree that the original request really hasn't been implemented.
    The calculations are all still numeric.

    I think the request is simple, in a PivotGridAggregateField, allow aggregates Min & Max to work with string data. This has straightforward functionality for strings, and would also work for the original poster where they want to represent pivot data where there would only be a single value, as well.

    It might make sense to have a PivotGridStringAggregateField that was similar, but more limited rather than making the existing field do it.

    Joel
  19. Milena
    Admin
    Milena avatar
    224 posts

    Posted 04 Aug 2014 Link to this post

    Hello,

    I completely understand your concerns,  however note that the required feature is not part of the Pivot engine possibilities and is out of the Pivot Engine scope of functionality. As we are building our control on the top of the base PivotGrid engine the same could not be independently implemented on our side in the RadPivotGrid control.

    You can find more information about PivotTable here

    Regards,
    Milena
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  20. Joel Kraft
    Joel Kraft avatar
    87 posts
    Member since:
    Jan 2004

    Posted 05 Aug 2014 in reply to Milena Link to this post

    Well that is disappointing to hear. I absolutely understand that the Excel PivotTable is an inspiration for this control, but that doesn't mean you have to be constrained by it.

    For my particular example with grades that I outlined above, I was actually able to make this work by converting the letter grades into numbers in my data source, and then converting them back into letters in the CellDataBound event.

    That is easy in situations with single characters or a finite number of options that are easy to decode.  If you are working with database data and the strings you want to display in a cell have some sort of unique numeric key, you can probably do it for more complex data, as well.

    This is only a workaround in very limited circumstances, though.
  21. Milena
    Admin
    Milena avatar
    224 posts

    Posted 11 Aug 2014 Link to this post

    Hello,

    You can log this request in our feedback portal.In case it receives enough votes, our dev team will review the item and will consider if it is possible to integrate your suggestion to the control.


    Regards,
    Milena
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  22. Andy
    Andy avatar
    2 posts
    Member since:
    Oct 2010

    Posted 09 Oct 2014 Link to this post

    I agree it would be nice if this worked out of the box, but I did find a work around. Just represent your strings as a numeric ID in your data set. Then on Cell Databound, look up that id and replace it with your text. For example...

    Private Sub grdPivot_CellDataBound(sender As Object, e As PivotGridCellDataBoundEventArgs) Handles grdPivot.CellDataBound
            If TypeOf e.Cell Is PivotGridDataCell Then
                Dim cell As PivotGridDataCell = DirectCast(e.Cell, PivotGridDataCell)
                If cell IsNot Nothing AndAlso DirectCast(cell.Field, PivotGridAggregateField).DataField = "OwnerEmployeeId" Then
                    Dim employeeId As Integer = cell.Text
                    If employeeId = 0 Then
                        cell.Text = ""
                    Else
                        Dim owners As List(Of vwProductLineOwnership) = DirectCast(grdPLOPivot.DataSource, List(Of vwProductLineOwnership))
                        Dim owner As vwProductLineOwnership = owners.FirstOrDefault(Function(o) o.OwnerEmployeeId IsNot Nothing AndAlso o.OwnerEmployeeId = employeeId)
                        If owner IsNot Nothing Then
                            cell.Text = owner.OwnerName
                        End If
                    End If
                End If
            End If
        End Sub
  23. Milena
    Admin
    Milena avatar
    224 posts

    Posted 14 Oct 2014 Link to this post

    Hello Andy,

    Thank you for providing your solution here.

    Regards,
    Milena
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017