Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 512
SFun28 Avatar asked Mar 29 '11 14:03

SFun28


People also ask

How do I change the Summarize values in a pivot table?

In the PivotTable, right-click the value field you want to change, and then click Summarize Values By. Click the summary function you want. Note: Summary functions aren't available in PivotTables that are based on Online Analytical Processing (OLAP) source data. The sum of the values.


1 Answers

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.

like image 187
Charles Williams Avatar answered Sep 28 '22 07:09

Charles Williams