Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • Hello,

                                    I would like to find out if the following scenario can be accomplished using ASPxPivotGrid.
                                    I have two fields in row area: Group and SubGroup. This fields have the same GroupIndex value.
                                    There are two available values for Group filter (Group1 and Group2). There are four available

                                    values for SubGroup filter (SubGroup 11, SubGroup 12, SubGroup 21, SubGroup 22). Moreover, in

                                    my data source Subgroups 11 and 12 can be met only for Group 1 and SubGroups 21 and 22 for

                                    Group 2 accordingly.

                                    When I filter my ASPxPivotGrid by Group 1 value I am still able to pick all subgroups in the SubGroup field filter. Is there a way to allow picking only Subgoup 11 and Subgroup 12 in Subgroup filter when Group 1 is picked in Group filter?

                                    The sample application is attached.

                                    Kindest regards,
                                    Ivan

                                DxSample Independent Filtering.rar
                                0

                                Hi Ivan,

                                I’m sorry, but this cannot be implemented in the current version. I've converted your question to a suggestion. We'll add the HeaderFilterFillItems server-side event. This event will be raised before the filter dropdown is shown, and will enable you to provide custom filter items.

                                Thank you,
                                Nathan

                                0

                                Hi Nathan,

                                The HeaderFilterFillItems server-side event is great. But don't you think that for the case, when fields are included in the same group (using GroupIndex property), it would be convenient to turn on the behavior I was writing about using a property (something like bool FilterValuesAreRelatedWithParent { get; set; }).

                                Best regards,
                                Ivan

                                0

                                Hello Ivan,

                                I'm sorry for the delay in responding. We're going to implement an hierarchical filter drop down in 9.1 like that is done in Excel 2007. This should solve your task but in a bit different way.

                                Thanks,
                                Ivan

                                0

                                That would be great. Thank you

                                0

                                Hello,

                                Has this feature been implemented by now?

                                Best regards,
                                Ivan

                                0

                                Hello Ivan,

                                Unfortunately, no. Please track its status on the following page: Add an Excel2007-like filter popup with a tree view that supports the loading of tree view items on callbacks .

                                Thanks,
                                Ivan

                                0

                                Thank you. I really hope it will be done, as hierarchical dimensions are pretty common in business intelligence.

                                0

                                Hello Ivan,

                                In 10.2, we have implemented the ASPxPivotGrid.CustomFilterPopupItems event, which will help you accomplish your task. This event is raised when an end-user tries to invoke the filter drop-down, thus allowing you to remove particular filter items.
                                For more information, see the Using the CustomFilterPopupItems Event to Manage Filter Items in 10.2 blog post.

                                Thanks,
                                Basil

                                You must  log in  or  register  to leave an answer

                                Is your intention to post an answer to your own question?

                                • If so, then proceed.
                                • If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
                                • If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.

                                To start a chat you should create a support ticket


                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Your Privacy - Legal Statements

                                Copyright © 1998-2013 Developer Express Inc.
                                ALL RIGHTS RESERVED
                                All trademarks or registered trademarks
                                are property of their respective owners