excel - 如何忽略数据透视表中特定字段的特定过滤器？

Question

是否可以忽略数据透视表中特定值的过滤器？在下面的示例中，我想Bug Type忽略Test Id

我想将ETeam 中包含测试数量和错误数量（没有 Type ）的表格放入数据透视表中？

最后，目标是按团队构建条形图。

数据

Test Id | Test Team  | Bug Type | Bug Id | Bug Team
1       | Team1      | E        | 1000   | Team1
2       | Team2      | B        | 1200   | Team1
        |            | B        | 1300   | Team2
3       | Team3      | E        | 1400   | Team3
4       | Team4      |          |        | Team5
5       | Team4      | B        | 1500   | Team5

预期结果

Team  | Distinct count of test | Distinct Count of Bug
Team1 | 1                      | 1
Team2 | 1                      | 1
Team3 | 1                      | 0
Team4 | 2                      | 0
Team5 | 0                      | 1

有可能吗？Mover，如您所见，Team是两列 (Bug Team和Test Team) 的合并吗？

先感谢您

标签： excelexcel-formulapivot-table