I've got a chart showing, and of course the data that was bound to it, but I need to display it differently..
我有一个图表显示，当然还有绑定到它的数据，但我需要以不同的方式显示它。
This is how I have the table now:
这就是我现在的表格：
and this is how I need it:
这就是我需要的方式：
But without hardcoding most of it I can't think of how to get it from the first to the second, any ideas? :/
但是如果没有大部分的硬编码，我想不出如何从第一个到第二个，任何想法？ ：/
Extra explanation if it wasn't clear: I need the first column to become just one row for each region, then all the possible test statuses to become a column, with the test count being displayed for each region/test, grand total isn't that important
如果不清楚则需要额外说明：我需要第一列成为每个区域的一行，然后所有可能的测试状态成为一列，每个区域/测试显示测试计数，总计不是'这很重要
1 个解决方案
#1
1
What you show there is know as a cross-tab, matrix, or most commonly a pivot table, because you are pivoting a column of values into headers.
您在那里展示的内容被称为交叉表，矩阵或最常见的数据透视表，因为您正在将一列值转换为标题。
This can be accomplished many ways.
这可以通过多种方式实现。
- Using an OLAP or analytical engine.
- 使用OLAP或分析引擎。
- Using something like Excel to create a pivot table.
- 使用Excel之类的东西来创建数据透视表。
- Using a reporting engine that supports pivots.
- 使用支持枢轴的报告引擎。
- Using a pivot or OLAP framework component(there are many that vary from database oriented, to simply in memory manipulation, to client side visual controls)
- 使用pivot或OLAP框架组件（有许多不同于面向数据库，简单地在内存操作中，到客户端可视控件）
- Using an SQL PIVOT query
- 使用SQL PIVOT查询
You'll need to evaluate your architecture and user requirements to determine what combination best fits your needs.
您需要评估您的架构和用户需求，以确定最适合您需求的组合。
#1
1
What you show there is know as a cross-tab, matrix, or most commonly a pivot table, because you are pivoting a column of values into headers.
您在那里展示的内容被称为交叉表，矩阵或最常见的数据透视表，因为您正在将一列值转换为标题。
This can be accomplished many ways.
这可以通过多种方式实现。
- Using an OLAP or analytical engine.
- 使用OLAP或分析引擎。
- Using something like Excel to create a pivot table.
- 使用Excel之类的东西来创建数据透视表。
- Using a reporting engine that supports pivots.
- 使用支持枢轴的报告引擎。
- Using a pivot or OLAP framework component(there are many that vary from database oriented, to simply in memory manipulation, to client side visual controls)
- 使用pivot或OLAP框架组件（有许多不同于面向数据库，简单地在内存操作中，到客户端可视控件）
- Using an SQL PIVOT query
- 使用SQL PIVOT查询
You'll need to evaluate your architecture and user requirements to determine what combination best fits your needs.
您需要评估您的架构和用户需求，以确定最适合您需求的组合。