I have a db table (tbCriteriaResults) such as:
- Criteria No
I want to create a crosstab resultset such as:
- Criteria No 9
- Criteria Position 9
- Criteria No 10
- Criteria Position 10
- Performance Point
As you can see , performance point is a calculated column. And it sums all values of criteria columns. For example for Store ID 1:
For store ID 2:
I have attached a screenshot and you will exactly understand what I want.
Please help... How can I do this?