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

                                    Question regarding DS45087. It describes functionality I need very much. DS45087 was marked recently as implemented in 7.1.1. It is true? I haven't found it in "What's new" list of 7.1.1 or 7.1.2 releases.
                                    I also checked PivotGrid demo modules, PivotGrid designer and official help shipped with 7.1.2 download. I can not find any information how to achieve this functionality.

                                    Regards, Przemyslaw Wlodarczak

                                You must  log in  or  register  to leave comments

                                1 Solution

                                0

                                Hi Przemyslaw,

                                This behavior can be implemented using options introduced in version 7.1.1.
                                Add another field to the Data area with the same fieldname. Set this field's SummaryType property to a different type than the original field. And set its Options.ShowValues and Options.ShowTotals properties to False.

                                The DXperience 7.1 "What's new" topic describes this feature as "You can now suppress totals or even value cells for individual fields."

                                Please let us know if this makes sense.

                                Thanks,
                                Michael.

                                • DAC Software sp. z o.o. 05.15.2007

                                  Hi Michael,

                                  Sorry for delay, I had some deadlines. Now I am back with my pivot project.

                                  Your workaround works for me, but only partially:
                                  -first, I find this not obvious, especially for new users. If I am not familiar to XtraPivotGrid, I would rather look for something similar to CustomTotals (but related to grand totals).
                                  -second, much more important, there are two data headers in data area instead of one. This looks strange and causes trouble when one tries to customize layout (by moving data headers between areas, hiding or showing fields)

                                  Regards, Przemyslaw

                                • DAC Software sp. z o.o. 05.15.2007

                                  One more question:
                                  Second grand total placed with additional field in data area appears only as column grand total. I can only switch between ColumnArea and RowArea with pivotGrid.OptionsDataField.Area property.
                                  But I need two grand totals to be shown in columns and in rows. Is it possible now, with your workaround?

                                  Regards, Przemyslaw

                                • Hi Przemyslaw,

                                  Sorry, there is no other way to implement multiple grand totals.
                                  Multiple grand totals can be shown either in columns or rows. There is no option to show them all simultaneously.
                                  If you wish, you can post a suggestion to implement this functionality differently to our Support Center.

                                  Thanks,
                                  Michael.

                                • DAC Software sp. z o.o. 05.16.2007

                                  Hi Michael,

                                  I will reopen my DS45087 suggestion and add additional explanation. I will add another one

                                  Regards, Przemyslaw

                                • DAC Software sp. z o.o. 05.16.2007

                                  Hi Michael,

                                  I will reopen my DS45087 suggestion and add additional explanation. I will add another one for simultaneously showing multiple grand totals in columns and rows

                                  Regards, Przemyslaw

                                You must  log in  or  register  to leave comments

                                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.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners