ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   PivotTable Functions (https://www.excelbanter.com/charts-charting-excel/421-pivottable-functions.html)

astrodon

PivotTable Functions
 
I have been searching to find a way to use statistical functions in a
pivot table. I have several very fine books one of which is MS Data Analysis
and Business Modeling; A Complete Guide to Pivot Tables: A Visual Approach.
But have not been able to find what I need there or on the net, forums, etc.

Does anyone know of a source that would demonstrate creating calculated
fields
such as =Median(Ratio) and produce the actual Median for a given group and
not the Sum, Average, Count... of Median. ARGH!

TIA

Donald R. Cossitt
Wheeler County Assessor

--
The writing of books there is no end


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com