Is there anyways to create a custom "summarize value field by" function to be used in an XL 2007 pivot table. The standard Sum, Count, Average, Max, etc. are not sufficient for me. I would accept a solution in VBA, or a solution that requires an XLA or XLL.
无论如何都要创建一个自定义的“汇总值字段”功能，以便在XL 2007数据透视表中使用。标准的Sum，Count，Average，Max等对我来说还不够。我会接受VBA的解决方案，或者需要XLA或XLL的解决方案。
please note that I'm NOT asking about Calculated Field or Calculated Item. Neither serve my purpose - I need to summarize the underlying data with functions such as Median, 1st Quartile, etc.
请注意，我不是在询问计算字段或计算项目。两者都不符合我的目的 - 我需要用Median，1st Quartile等函数来总结基础数据。
2 个解决方案
#1
1
No this is not possible with Excel pivot tables, even in Excel 2010.
Using the PowerPivot Excel 2010 addin I believe its possible to effectively create this kind of function using DAX, and MDX has more built-in functions such as MEDIAN.
即使在Excel 2010中，Excel枢轴表也是不可能的。使用PowerPivot Excel 2010插件我相信可以使用DAX有效地创建这种功能，而MDX具有更多内置函数，如MEDIAN。
#2
0
Unless I hear otherwise, I'm going to close out this questions with the following answer: No, this cannot be done.
除非我另有说明，否则我将用以下答案结束这些问题：不，这不可能。
#1
1
No this is not possible with Excel pivot tables, even in Excel 2010.
Using the PowerPivot Excel 2010 addin I believe its possible to effectively create this kind of function using DAX, and MDX has more built-in functions such as MEDIAN.
即使在Excel 2010中，Excel枢轴表也是不可能的。使用PowerPivot Excel 2010插件我相信可以使用DAX有效地创建这种功能，而MDX具有更多内置函数，如MEDIAN。
#2
0
Unless I hear otherwise, I'm going to close out this questions with the following answer: No, this cannot be done.
除非我另有说明，否则我将用以下答案结束这些问题：不，这不可能。