Tim Larson
Top achievements
Rank 1
Rank 1
Tim Larson
asked on 17 Dec 2015, 04:54 PM
I am using the pivot grid and have a field called Category and Subcategory when I filter down The Category the Subcategory should only show the fields that are associated with the given category. Right now it shows all of the subcategory records and makes it hard to work with.
How would I implement this?
Thanks,
Tim
5 Answers, 1 is accepted
0
Hello Tim,
Thank you for writing.
The observed behavior is expected and it follows the pivot behavior in excel which is the same. The items building the tree of the filter popup are populated according to the distinct values provided by the group descriptor. Once a filter gets applied to the group descriptor the popup is updated to display only the items passing the filter.
Applying a filter on a different level does not automatically update the nodes collection of the other group descriptors. Hiding certain nodes from a popup of a descriptor element which is a subcategory of another descriptor element is possible. For the purpose, you would need to store the unique filtered items of the parent category and once the filter popup of the subcategory is shown, hide nodes according to the filter. Please not that it is not a simple task and may not cover all possible cases.
I am sending you a sample project showing a sample implementation as well as a short animation 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
Thank you for writing.
The observed behavior is expected and it follows the pivot behavior in excel which is the same. The items building the tree of the filter popup are populated according to the distinct values provided by the group descriptor. Once a filter gets applied to the group descriptor the popup is updated to display only the items passing the filter.
Applying a filter on a different level does not automatically update the nodes collection of the other group descriptors. Hiding certain nodes from a popup of a descriptor element which is a subcategory of another descriptor element is possible. For the purpose, you would need to store the unique filtered items of the parent category and once the filter popup of the subcategory is shown, hide nodes according to the filter. Please not that it is not a simple task and may not cover all possible cases.
I am sending you a sample project showing a sample implementation as well as a short animation 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
0
Alex Dybenko
Top achievements
Rank 2
Rank 2
answered on 13 Oct 2016, 10:49 AM
Hi,
I am looking for this sample project, but link is broken, is it possible to restore it?
Alex
0
Hello Alex,
Indeed the link appears to be broken.
I am attaching again the project. Please note that this behavior is not supported and the solution might not cover all possible cases.
I hope this helps. Should you have further questions please do not hesitate to write back.
Regards,
Hristo Merdjanov
Telerik by Progress
Indeed the link appears to be broken.
I am attaching again the project. Please note that this behavior is not supported and the solution might not cover all possible cases.
I hope this helps. Should you have further questions please do not hesitate to write back.
Regards,
Hristo Merdjanov
Telerik by Progress
Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms. For more information check out this blog post and share your thoughts.
0
Alex Dybenko
Top achievements
Rank 2
Rank 2
answered on 13 Oct 2016, 12:49 PM
Hi Hristo,
can you pls check, both old and new links are broken
Alex
0
Hi Alex,
We are currently experiencing an issue with our forums which will be resolved as soon as possible. In case the matter is urgent you can open a ticket and I will send you the project there.
I hope this helps.
Regards,
Hristo Merdjanov
Telerik by Progress
We are currently experiencing an issue with our forums which will be resolved as soon as possible. In case the matter is urgent you can open a ticket and I will send you the project there.
I hope this helps.
Regards,
Hristo Merdjanov
Telerik by Progress
Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms. For more information check out this blog post and share your thoughts.