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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With