Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Pratik
305
How to achieve customized filtering in Pivot Grid
posted

Hi Team,

Please help me over the below issue.

I want to achieve a customized filtering on the pivot data

The attached image shows 2 table

Upper Table - Before Filter

Below Table - After Filter

Real Scenario : If we apply some filter from the area field filter symbol of data selector . The filtered rows are shown and other rows are hidden 

Expected Result : If we apply some filter from the area field filter symbol of data selector . The filtered rows should show the values and other rows should display 0 instead of hiding

On Applying filter the column A1 to A9 should show filter values against their cell,  i.e. actual value or 0

Sincerely,

Pratik Vishwakarma

  • 27093
    posted

    Hello Pratik,

    I have been looking into your requirement and there is no such built-in functionality in the XamPivotGrid and I also could not find a proper way to tackle the issue. You can suggest new Product Ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.

    Steps to create your idea:
                   
    1. Log into the Infragistics Product Ideas site at http://ideas.infragistics.com (creating a new login if needed).
    2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)
    3. Add your product idea and be sure to be specific and provide as much detail as possible. Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!

    The benefits of submitting the product idea yourself include:
    - Direct communication with our product management team regarding your product idea.
    - Notifications whenever new information regarding your idea becomes available.

    Additional benefits of the Product Idea system include:

    - Ability to vote on your favorite product ideas to let us know which ones are the most important to you.  You will have ten votes for this and can change which ideas you are voting for at any time.
    - Allow you to shape the future of our products by requesting new controls and products altogether.
    - You and other developers can discuss existing product ideas with members of our Product Management team.

    The product ideas site allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.

  • 34510
    Offline posted

    Hi Pratik,

    I'm looking into whether this is possible or not.  The default implementation is to remove the rows that don't match the filter so you will probably need a custom filter of some kind to keep that from happening.  I'll get back to you after my investigation.