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

WILL PIVOT GRID SHOW THE STRING VALUES...?

21 Answers 584 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Dhamodharan
Top achievements
Rank 1
Dhamodharan asked on 21 Aug 2012, 08:07 AM
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

21 Answers, 1 is accepted

Sort by
0
Milena
Telerik team
answered on 23 Aug 2012, 01:39 PM
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.
0
Girish
Top achievements
Rank 1
answered on 31 Aug 2012, 04:29 PM
This a really simple question. How do you display text values in the pivot cells (all examples show numbers)
0
Milena
Telerik team
answered on 03 Sep 2012, 03:18 PM
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.
0
Dhamodharan
Top achievements
Rank 1
answered on 04 Sep 2012, 08:17 AM
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
0
Milena
Telerik team
answered on 05 Sep 2012, 03:02 PM
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.
0
Martin
Top achievements
Rank 1
answered on 03 Oct 2012, 10:01 PM
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,
0
Milena
Telerik team
answered on 08 Oct 2012, 03:58 PM
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.
0
Joel Kraft
Top achievements
Rank 2
answered on 01 Nov 2012, 04:19 PM
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
0
Joel Kraft
Top achievements
Rank 2
answered on 05 Nov 2012, 04:23 PM
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!
0
Milena
Telerik team
answered on 06 Nov 2012, 08:45 AM
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.
0
Prabu
Top achievements
Rank 1
answered on 08 Aug 2013, 12:03 PM
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
0
Milena
Telerik team
answered on 09 Aug 2013, 03:43 PM
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.
0
Piotr
Top achievements
Rank 1
answered on 17 Oct 2013, 06:01 AM
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
0
Milena
Telerik team
answered on 21 Oct 2013, 02:21 PM
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.
0
Rob Anderson
Top achievements
Rank 1
answered on 30 Jul 2014, 01:12 PM
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.
0
Joel Kraft
Top achievements
Rank 2
answered on 31 Jul 2014, 02:45 PM
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
0
Milena
Telerik team
answered on 04 Aug 2014, 12:00 PM
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.

 
0
Joel Kraft
Top achievements
Rank 2
answered on 05 Aug 2014, 10:17 PM
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.
0
Milena
Telerik team
answered on 11 Aug 2014, 06:57 AM
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.

 
0
Andy
Top achievements
Rank 1
answered on 09 Oct 2014, 04:45 PM
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
0
Milena
Telerik team
answered on 14 Oct 2014, 01:08 PM
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.

 
Tags
PivotGrid
Asked by
Dhamodharan
Top achievements
Rank 1
Answers by
Milena
Telerik team
Girish
Top achievements
Rank 1
Dhamodharan
Top achievements
Rank 1
Martin
Top achievements
Rank 1
Joel Kraft
Top achievements
Rank 2
Prabu
Top achievements
Rank 1
Piotr
Top achievements
Rank 1
Rob Anderson
Top achievements
Rank 1
Andy
Top achievements
Rank 1
Share this question
or