excel数据透视表 - 多列 [英] excel pivot table - multiple columns
问题描述
我正在使用以下数据在Excel中创建一个数据透视表:
I'm trying to create a pivot table in Excel using the following data:
我试图想出的最终结果(使用pivot)是一个这样的摘要:
The end result I'm trying to come up with (using the pivot) is a summary like this:
然而,我不知道如何让Excel计数/添加/考虑所有的列。我可以为每个单独的字段/列创建一个枢纽,但无法弄清楚如何一起编译数据。
However I can't figure out how to get Excel to count / add / consider all columns. I can create a pivot for each individual field/column, but can't figure out how to compile the data together.
推荐答案
请原谅这个图片中的mac excel,但这里是如何设置数据透视表。
Forgive the mac excel in the picture but here is how you can set up a pivot table.
请注意,行标签只会反映列中的类别放在行部分
Note though that the row labels will reflect only categories that are in the column you put in the row section
这篇关于excel数据透视表 - 多列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!