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
225
Group by on two column values
posted

I have a data as given below.  Kindly let me know, how do I group on two column values.  If it is a single column values, I can do it.  Also lot of forms says, column evaluator property will solve this.  I have no idea.  Kindly let me know, how to achieve  this below functionality

 

RawData

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Product

Type

Name

Category

Brand

Zone

Value

Sales

P1

1

Product-1

C1

B1

Z1

100

10

P1

2

Product-1

C1

B1

Z1

200

20

P1

3

Product-1

C1

B1

Z1

300

30

 

 

 

 

 

 

 

 

P2

1

Product-2

C1

B2

Z1

10

1

P2

2

Product-2

C1

B2

Z1

20

2

P2

3

Product-2

C1

B2

Z1

30

3

 

 

 

 

 

 

 

 

P3

1

Product-3

C1

B3

Z2

30

12

P3

2

Product-3

C1

B3

Z2

40

24

P3

3

Product-3

C1

B3

Z2

50

36

 

 

 

 

 

 

 

 

Output Required

 

 

 

 

 

 

GroupHeader: Z1 + B1

 

 

 

 

 

'

 

P1

1

Product-1

 

100

10

 

 

P1

2

Product-1

 

200

20

 

 

P1

3

Product-1

 

300

30

GroupHeader: Z1 + B2

 

 

 

 

 

 

 

P2

1

Product-2

 

10

1

 

 

P2

2

Product-2

 

20

2

 

 

P2

3

Product-2

 

30

3

  • 48586
    posted

    Hello Hariharan,

     

    I am just checking about the progress of this issue. Did you solve your issue accordingly to the information that I provided you?

    Did you test the sample I have send to you? Is that what you looking for ?

    Let me know if you need any further assistance.

     

    Thank you for using Infragistics Components.

  • 48586
    Suggested Answer
    posted

    Hello Hariharan,

     

    As far I understand your scenario you want to GroupBy your UltraGrid based of two columns. I have created a sample for you that illustrates that behavior. Pleas look at the sample and let me know if you have any further questions.

    UltraGridMultipleGrouping.zip
  • 17259
    Offline posted

    I think "column evaluator property" is a column that combines the two values together:

    public string ZoneAndBrand

    {

    get { return Zone + " + " + Brand; }

    }