Excel数据透视表多个工作表的摘要

I have excel 2012 installed. I have a Excel which has two sheets. This excel is a summary of errors in each project till date.

我安装了excel 2012。我有一个有两张纸的Excel。这个excel是每个项目到目前为止的错误摘要。

Onesheet is a overall view of projects. This sheet has project_Id,Project_name,Total_errors

Onesheet是项目的整体视图。此工作表具有project_Id,Project_name,Total_errors

project_id||project_name||error
   3467   || project A  ||   5
   7890   || project B  ||   3

The second sheet has project_id,Project_name and location of each error.

第二个工作表有project_id,Project_name和每个错误的位置。

project_id||project_name||error
  3467    || project A  ||com.testsample.projecta.service.controller
  3467    || project A  ||com.testsample.projecta.domains.user
  3467    || project A  ||com.testsample.projecta.domains.product
  3467    || project A  ||com.testsample.projecta.domains.test
  3467    || project A  ||com.testsample.projecta.domains.test2
  7890    || project B  ||com.testsample.projectb.domains.product
  7890    || project B  ||com.testsample.projectb.domains.users
  7890    || project B  ||com.testsample.projectb.domains.details

now i have been given a task of making a pivot table such that when i double click on the "error" in the first sheet i should get the the list of error from the second sheet. The result can be in another sheet or same sheet. Could some please let me know how i can go ahead with this? Thanks.

现在我被赋予了制作数据透视表的任务,这样当我双击第一张表中的“错误”时,我应该从第二张表中获取错误列表。结果可以在另一张纸或同一张纸上。有些人可以告诉我如何才能继续这样做?谢谢。

1 个解决方案

#1

on a 3rd sheet to go insert, pivot table.

在第3张纸上插入,枢轴表。

select the range of values on sheet 2

选择工作表2上的值范围

setup pivot table as in image. (by default pivot table have double click to drill in)

像图像一样设置数据透视表。 (默认情况下,数据透视表有双击钻取)

image on bottom show results when you double click the pivot count of error value from the sheet 4 generated by the double click

当您双击双击生成的工作表4中的错误值的数据透视计数时,底部的图像显示结果

#1

on a 3rd sheet to go insert, pivot table.