BuyLog In
Ticket T147300
Visible to All Users

Pivot Grid ASP.NET module - How to change the summary type

created 11 years ago

[DevExpress Support Team: CLONED FROM B191875: The pivot grid is unusable for end users]
What about grouping by another statistics? It is always set to Sum Grand Totals, but I want other options (Average, Max, Min, etc.).
FYI: I'm using ASP.NET Web application.

Sign in to comment on this post

Answers approved by DevExpress Support

created 11 years ago (modified 10 years ago)

Hello Mauro,
Yes, it is possible. You just need to access the PivotGrid designer using Model Editor and customize required columns. I have attached a short video that illustrates this.
Please let me know if you need further assistance.

    Show previous comments (3)
    Anatol (DevExpress) 10 years ago

      You can access the ASPxPivotGrid control as shown here: pagination on pivot and chart.

      Alternatively, use a custom fields builder to customize the required fields. This solution is platform-independent. See examples here:

      How to make PivotGrid fields invisible when the Analysis view is initialized
      How to make PivotGridControl editable when using the Pivot Chart (Analysis) module
      Calculated property/field in Analysis report

      MA MA
      Mauro Assis 10 years ago

        Thanks, that's what I needed.

        Anatol (DevExpress) 10 years ago

          You are welcome!

          Sign in to comment on this post

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.