There will likely be some delay, depending on the size of your DataTable (columns and/or rows) and how much processing you're doing.  For most typical usage, I expect this delay to be minimal to the point where a user won't notice.

Hai McDonald,

I planned to create a new datatable, with seperate columns as you mention in your reply. I planned to do this in runtime. Is this cause any perform issues (like time delay)?

Hai Nick,

If i pivot my datasource, the result will be as follow :

Branch A                 Branch A                         Branch B                      Branch B

Customer A           Customer B                 Customer A                  Customer B

1200                        1500                              2000                              1000

This will not give the result what i need (as shown in previous post). Any idea?

If your datasource  is from SQL Server then it would be better to create a stored procedure to pivot the data for you. 

Nick

You can get a similar result in WinGrid by using its Outlook Group-By functionality.

Given your sample data, you'd group the grid by the "Customer" column.  This will give you a result like the following:

+ Customer:  A (2)
    Branch    Amount
    Branch A    1200
    Branch B    2000
+Customer:  B (2)
    Branch    Amount
    Branch A    1500
    Branch B    2500

If you want a result that appears more like the one you've listed in your previous post, you should instead create a new DataTable, where you've already created separate columns for Customer A and Customer B.  You can then bind this DataTable to WinGrid.