Milena

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.

Milena

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.

Milena

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.

Milena

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.

Joel Kraft

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.

Milena

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.

Prabu

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

Milena

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:

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.

Piotr

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

Milena

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.

Rob Anderson

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.

Joel Kraft

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

Milena

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.

Joel Kraft

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.

Andy

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

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.