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

PivotFieldList fields grouping

3 Answers 149 Views
PivotGrid and PivotFieldList
This is a migrated thread and some comments may be shown as answers.
Artemis
Top achievements
Rank 1
Artemis asked on 31 Aug 2015, 06:21 PM

I am using a PivotFieldList associated to a PivotGrid which is bound to an in-memory table.

The Grid and the Field List work OK, but my problem is my table has too many columns. More than 200.

This make it a bit difficult for the user to choose fields from the field list.

I was wondering if there is a way to group fields in the PivotFieldList. Something like the "date" fields. Each group would be a node opening on user click and showing the available column.

 

3 Answers, 1 is accepted

Sort by
0
Hristo
Telerik team
answered on 02 Sep 2015, 01:14 PM
Hello Artemis,

Thank you for writing.

RadPivotFieldList groups date fields by design. Additional information considering the Value and Label option you can find in the following documentation article: RadPivotFieldList.

I am sending you attached a sample project showing how a date column is grouped in the field list editor, I am also sending you a gif file with the result on my end.

I hope this helps. Should you have further questions please do not hesitate to write back. 

Regards,
Hristo Merdjanov
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Artemis
Top achievements
Rank 1
answered on 02 Sep 2015, 02:16 PM

Hi Hristo, thanks for your reply.

I understand the date fields grouping is by design.

What I am trying to do is to make it easier for the user to select a field out of 200 fields listed in the RadPivotFieldList. I was thinking of splitting them in groups, each group shown as a node, and opening on user click to show the group fields. I guess this is not possible.

Is it possible to hide fields in the RadPivotFieldList, without deleting them from the table, so that I could create an external toolbar that would hide / show groups of fields, according to the user selection?

Any other ideas / suggestions are welcome.

Regards,

Artemis

0
Hristo
Telerik team
answered on 07 Sep 2015, 12:29 PM
Hello Artemis,

Thank you for writing back.

You could manipulate the Nodes collection of the tree contained in your RadPivotFieldList and move selected node to newly created parent nodes added to the tree. Since the control has its own logic for reordering and adding the nodes, you would need to perform this operation every time the data in the pivot grid gets updated.

I have modified my project to include a working example which should get you going. In case, you decide to go with the other solution and create a toolbar and later hide fields in the tree, you are going to need to iterate your nodes collection and set the Visible property of the selected node to false.

Besides my project, I am also sending you a gif file showing the result on my end.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo Merdjanov
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
PivotGrid and PivotFieldList
Asked by
Artemis
Top achievements
Rank 1
Answers by
Hristo
Telerik team
Artemis
Top achievements
Rank 1
Share this question
or