Hi,
I have a .csv file which automatically updates with sales data. This data is loaded into a datagridview, but is there a way to display this into a datagridview matrix ?
Data is as follows;
Header as:
Person, Sales, Area
Data as:
Person 1, £200, North
Person 2, £100, South
Person 3, £95, North
Person 4, £500, West
Person 5, £400, North
Person 1, £200, East
Person 1, £500, North
and so on...we have 8 sales people but they will often visit other areas. The list is over 100 transactions.
Is it possible to achieve the following;
Have the data showing as a datagrid similar to a matrices, i.e.
The data already sits in a datagridview, but I would want to count how many times their sales have appeared and counts these.
Also would it be possible for the North, South, East and West to load from the datagridview, rather than me fixing these.
Many thanks for any advice given.
I have a .csv file which automatically updates with sales data. This data is loaded into a datagridview, but is there a way to display this into a datagridview matrix ?
Data is as follows;
Header as:
Person, Sales, Area
Data as:
Person 1, £200, North
Person 2, £100, South
Person 3, £95, North
Person 4, £500, West
Person 5, £400, North
Person 1, £200, East
Person 1, £500, North
and so on...we have 8 sales people but they will often visit other areas. The list is over 100 transactions.
Is it possible to achieve the following;
Have the data showing as a datagrid similar to a matrices, i.e.
North | South | East | West | |
Person 1 | 2 | 0 | 1 | 0 |
Person 2 | 0 | 1 | 0 | 0 |
Person 3 | 0 | 0 | 0 | 1 |
Person 4 | 0 | 0 | 0 | 1 |
Person 5 | 1 | 0 | 0 | 0 |
The data already sits in a datagridview, but I would want to count how many times their sales have appeared and counts these.
Also would it be possible for the North, South, East and West to load from the datagridview, rather than me fixing these.
Many thanks for any advice given.