I have a GridView on an aspx web form which I am designing with visual studio 2005.
the grid view shows month along the top, customer name along the side, and displays the number of tasks done by each customer per month.
I want to calculate the percentage difference between two subsequent months for each customer, so I can see the month on month increase or decrease in tasks done. I want this calculated figure to appear in each cell next to the actual amount (ie no new columns needed)
Thus far the gridview has been populated with th SQL statement. Is there a way of doing this programatically/ visually that doesnt involve playing with the SQL