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
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
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
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
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
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,
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
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
Hopefully this can be added in the future, or we can get custom aggregates!
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
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
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
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
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
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
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.
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.
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.
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
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.