Can I create a custom summary field in Excel 2007 pivot table?
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.
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.
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.
Unless I hear otherwise, I'm going to close out this questions with the following answer: No, this cannot be done.
精彩评论