Hello, everyone.

I'm not sure if I'm on the right road so I'll just describe what I need in the end first.

I have a data table a simplified version of which is represented below:

Code:
 Number | Group | Date  | Client       | Amount
--------+-------+-------+--------------+--------
      1 | 220   | 28/12 | Company A    |   0.345
--------+-------+-------+--------------+--------
      2 | 220   | 29/12 | Company B    |   0.451
--------+-------+-------+--------------+--------
      3 | 240   | 26/12 | Company A    |   0.510
--------+-------+-------+--------------+--------
      4 | 240   | 27/12 | Company A    |   0.510
--------+-------+-------+--------------+--------
      5 | 220   | 30/12 | Company C    |   0.151
etc.

I have a default view which represents the whole table.

But I need also a different view which represents the summary of the same data.

Code:
 Code | Amount
------+--------
  220 |  0.947
------+--------
  240 |  1.02
In other words, I need grouped totals.

The question is - is it possible to accomplish by preparing a dataview for the datatable and assign it to the .DefaultView property (I need a user to be able to switch between detailed and summary views).
Normally I always prepare views in a database but now I need to do it with DataTable and I simply have no experience of working with DataView class.
Can somebody show me how it's done?