链接表以生成数据透视表Excel 2010 [英] Linking tables to make Pivot Table Excel 2010

问题描述

大家好，


我有一个电子表格，上面有两个数据源。表1列出了我在工作的医院从病房出院的病人数据，表2列出了医院所有病房的清单。我可以很容易地从表1中制作一个数据透视表，但是它只会列出表1中的病房。有些病房可能在一段时间内没有出院病人，但在最终报告中仍然需要。我想到的唯一方法是将两个表连接在一起，但我不知道如何在Excel 2010中实现它。


所有的帮助将一如既往地受到赞赏！

Hi all,

I have a spreadsheet which has two data sources on. Table 1 has data relating to patients who have been discharged from the wards at the hospital I work at and Table 2 has the list of all the wards at the hospital. I can make a pivot table from table 1 easily however it will only list the wards present in table 1. Some of the wards may not have discharged patients for some time but are still required on the final report. The only way I thought of doing that would be to link the two tables together but I don''t know how to/ if it''s possible do it in Excel 2010.

All help would be appreciated as always!

推荐答案

只有数据库可以有关系，你可以研究bout power pivot或access。

或者只是你的想法就像从表2中查找信息以添加到表1

only Database can have relation ship, you could study bout power pivot or access.
or just simply your idea like "lookup information from table 2 to add to table 1"

DavidAustin

这不是一件容易完成的任务。

两个链接：

+ MS：将多个工作表合并为一个数据透视表

+ PDF：数据透视表和PivotCharts？多张草原大草原状态


如果这些来源都没有帮助，请回复。

DavidAustin
This is not an easy task to accomplish.
Two links:

+MS: Consolidate multiple worksheets into one PivotTable report

+ PDF: PivotTables and PivotCharts ? Multiple Sheets Prairie State

If neither if these sources help, please post back.

你好zmbd和hvsummer，

我无法使用Access进行此项目，我正在运行Excel 2010，因此电源枢轴也不可用。


我之前尝试过这两个链接不幸的是，方法并不能使它们工作。我花了很多时间寻找方法让它运转起来却找不到任何东西。我尝试使用MS查询来加入表格，但最终在枢轴表格中，这给出了与未使用的病房相对应的日期空白，当隐藏时会从报告中消失。


我之前的解决方案 ;对于这个问题是使用大量的sumproduct公式，这些公式需要花费很长时间才能加载并在数据被删除时不断给出ref错误，所以我只是想简化整个过程！

Hi zmbd and hvsummer,

I cannot use Access for this project and I am running Excel 2010 so power pivot is not available either.

I have previously tried both of the linked methods and cannot get them to work unfortunately. I''ve spent quite a lot of time searching for ways to get it working and can''t find anything. I tried using MS query to join the tables but in the end pivottable this gives blanks for dates corresponding the unused wards, which when hidden would disappear from the report.

My previous "solution" for this problem was to use a vast range of sumproduct formulas which would take ages to load and constantly give ref errors when data was removed so I''m just looking to streamline the whole process!

这篇关于链接表以生成数据透视表Excel 2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！