I am trying to design a gridview that has a couple requirements that seem to need dynamic generation:
- The first column lists a product line pulled from the gridview datasource, no big deal there...
- All other columns and their headings need to be generated by results of a query to a table that lists metrics the customer wants (avg time to close, etc).
- I need to specifically perform calculations on each cell under each metric name using the product line given in the first column.
How can this be done?