Hello,

I am not sure what you want exactly. If you want to sum by 'part12' in the last visible row, how would you want to achieve it? One of the columns is of type string and the other is of type integer as far as I can see.

I can not upload the zip. please update your dataSource.

//
            // ultraDataSource1
            //
            ultraDataColumn4.DataType = typeof(short);
            ultraDataColumn5.DataType = typeof(ushort);
            this.ultraDataSource1.Band.Columns.AddRange(new object[] {
            ultraDataColumn1,
            ultraDataColumn2,
            ultraDataColumn3,
            ultraDataColumn4,
            ultraDataColumn5});
            this.ultraDataSource1.Rows.AddRange(new object[] {
            new Infragistics.Win.UltraWinDataSource.UltraDataRow(new object[] {
                        ((object)("part1")),
                        ((object)("A")),
                        ((object)("part2")),
                        ((object)("S")),
                        ((object)("part4")),
                        ((object)(((short)(5))))}),
            new Infragistics.Win.UltraWinDataSource.UltraDataRow(new object[] {
                        ((object)("part1")),
                        ((object)("B")),
                        ((object)("part2")),
                        ((object)("S")),
                        ((object)("part4")),
                        ((object)(((short)(10))))}),
            new Infragistics.Win.UltraWinDataSource.UltraDataRow(new object[] {
                        ((object)("part1")),
                        ((object)("C")),
                        ((object)("part2")),
                        ((object)("S")),
                        ((object)("part4")),
                        ((object)(((short)(5))))}),
            new Infragistics.Win.UltraWinDataSource.UltraDataRow(new object[] {
                        ((object)("part1")),
                        ((object)("A")),
                        ((object)("part2")),
                        ((object)("S")),
                        ((object)("part4")),
                        ((object)(((short)(5))))}),
            new Infragistics.Win.UltraWinDataSource.UltraDataRow(new object[] {
                        ((object)("part1")),
                        ((object)("A")),
                        ((object)("part2")),
                        ((object)("T")),
                        ((object)("part4")),
                        ((object)(((short)(35))))}),
            new Infragistics.Win.UltraWinDataSource.UltraDataRow(new object[] {
                        ((object)("part1")),
                        ((object)("B")),
                        ((object)("part2")),
                        ((object)("T")),
                        ((object)("part4")),
                        ((object)(((short)(20))))}),
            new Infragistics.Win.UltraWinDataSource.UltraDataRow(new object[] {
                        ((object)("part1")),
                        ((object)("B")),
                        ((object)("part2")),
                        ((object)("T")),
                        ((object)("part4")),
                        ((object)(((short)(25))))}),
            new Infragistics.Win.UltraWinDataSource.UltraDataRow(new object[] {
                        ((object)("part1")),
                        ((object)("C")),
                        ((object)("part2")),
                        ((object)("S")),
                        ((object)("part4")),
                        ((object)(((short)(15))))})});

This is not what I want, what I want is the last line by PART12 grouped totals. TKS

Hello,

Could you please review the sample attached to this post and see if it meets your requirements. Please feel free to let me know if I misunderstood you or if you have any other questions.

HOW TO FORMULA BY PART12?  WHEN PART12 CHANGE???