Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Median in pivot tables
Is it still the case where the median formula can not be used in pivot
tables. If this can be done, how do I add it? Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Median in pivot tables
You can use several formulae within the pivot function. Information is
available in Excel Help (reproduced below)....keywords "pivot median" in the help box should find the source. Hope this helps. Change how PivotTable or PivotChart data is summarized In a PivotTable report, click the data field or a cell in the data area. For a PivotChart report, work in the associated PivotTable report. On the PivotTable toolbar, click Field Settings . In the Summarize by box, click the summary function you want to use. For some types of source data, and for calculated fields and fields with calculated items, you can't change the summary function. If you want to use a custom calculation, click Options, click the calculation you want in the Show data as list, and then select a Base field and Base item, if these options are available for the calculation you chose, to provide the data for the calculation. The base field should not be the same one you chose in step 1. Note Setting Show data as to Normal turns off custom calculation. If the report has multiple data fields, repeat these steps for each one that you want to change. If your source data allows you to change the summary function, you can use more than one summary method for the same field. Drag the field from the PivotTable Field List window to the data area a second time, and then repeat the steps above for the second instance of the field -- RP "Donna S" wrote: Is it still the case where the median formula can not be used in pivot tables. If this can be done, how do I add it? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PLEASE add median in pivot tables PLEASE. PLEASE. | Excel Worksheet Functions | |||
Median in pivot tables | Excel Discussion (Misc queries) | |||
Median in pivot table | Excel Discussion (Misc queries) | |||
Can I use median function in Pivot Tables? | Excel Worksheet Functions |