Excel数据透视表——如何在行中检索单元格的值

I have some raw data as shown below.

我有一些原始数据，如下所示。

I created a Pivot Table for it, mainly just for formatting purposes (the ability to nicely group and expand the sub-items). The Pivot Table is shown below.

我为它创建了一个Pivot表，主要用于格式化目的(能够很好地对子项进行分组和展开)。数据透视表如下所示。

I need to display the LastUsageTime for each of the items (UsageName) listed in the Pivot Table. It is simply a lookup of the LastUsageTime column from the Raw Data.

我需要为Pivot表中列出的每个项(UsageName)显示最后的usagetime。它只是从原始数据中查找LastUsageTime列。

From my research so far, it looks like I have to use Index+Match to do the lookup to match all 3 columns (TPC, TeamProjectName, UsageName). Something like:

从我目前的研究来看，我似乎必须使用Index+Match来进行查找，以匹配所有3列(TPC、TeamProjectName、UsageName)。喜欢的东西:

{=INDEX('Raw Data'!A2:E2000,MATCH(1,('Raw Data'!A2:A2000=???????)*('Raw Data'!B2:B2000=??????)*('Raw Data'!C2:C2000=A6),0),5)}

However, I don't know what to use to retrieve the TPC and TeamProjectName of each UsageName in the Pivot Table.

但是，我不知道使用什么来检索Pivot表中的每个UsageName的TPC和TeamProjectName。

I hope this makes sense, and thanks for any help!

我希望这是有道理的，谢谢你的帮助!

1 个解决方案

#1

For the sake of an answer:

为了回答:

Process your LastUsedTime data into what is recognised by Excel as Date/Time and then add a field to your PivotTable for Σ VALUES Max of LastUsageTime (or Max of ... whatever the column of adjusted LastUsageTime data is labelled).

过程LastUsedTime数据到Excel所承认的日期/时间,然后将一个字段添加到数据透视表Σ值LastUsageTime马克斯(或马克斯……无论调整的LastUsageTime数据列是什么标签)。