Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions in a pivot table
Hi
I'm doing a pivottable. In the "values" field, I can choose between calculating the max, the mean, the standard deviation etc. But is there some way in which I can define my own funtions? For example, I'd like to calculate the median? Another thing: I'd like to make a graph that only uses the numbers in the pivottable, i.e., it changes when I change the parameters in the table. Is that possible? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions in a pivot table
Christian
If I understand, both things are possible (I am letting you know this for 2003 version) 1) You can define your own function in a PT and these then appear as new fields to place where you want. In the pivot table toolbar (this should appear when you select a PT) Look for formulas and calculated field. The dialog takes a bit of getting used to, but should be ok if you have got as far as a PT anyhow. 2) Just build a pivot chart from you pivot table (again via the PT toolbar) and any changes you make to the PT will reflect in the chart -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "Christian Stassen" <Christian wrote in message ... Hi I'm doing a pivottable. In the "values" field, I can choose between calculating the max, the mean, the standard deviation etc. But is there some way in which I can define my own funtions? For example, I'd like to calculate the median? Another thing: I'd like to make a graph that only uses the numbers in the pivottable, i.e., it changes when I change the parameters in the table. Is that possible? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions in a pivot table
Hi Nick
Thanks for the quick reply. I just tried, but can't seem to makeit do it right. The thing is, I have a lot of interest rates. I have calculated the average of these rates via the standard formula. But now I want to calculate the media of these rates. I tried going through the steps you mentioned, but when I was in "calculated field", I made a new field called median, and in the formula line i wrote =median(IRR). But instead of giving me the median of all the IRR's it gave me the median of the individual ones, to which I could then apply the standard formulas.. How do I get around this? Thanks "Nick Hodge" wrote: Christian If I understand, both things are possible (I am letting you know this for 2003 version) 1) You can define your own function in a PT and these then appear as new fields to place where you want. In the pivot table toolbar (this should appear when you select a PT) Look for formulas and calculated field. The dialog takes a bit of getting used to, but should be ok if you have got as far as a PT anyhow. 2) Just build a pivot chart from you pivot table (again via the PT toolbar) and any changes you make to the PT will reflect in the chart -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "Christian Stassen" <Christian wrote in message ... Hi I'm doing a pivottable. In the "values" field, I can choose between calculating the max, the mean, the standard deviation etc. But is there some way in which I can define my own funtions? For example, I'd like to calculate the median? Another thing: I'd like to make a graph that only uses the numbers in the pivottable, i.e., it changes when I change the parameters in the table. Is that possible? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text and special functions in Pivot table report | Excel Worksheet Functions | |||
Looking for gurus that knows show and hide functions on a pivot table? | Excel Worksheet Functions | |||
pivot table, functions for subtotals | Excel Worksheet Functions | |||
Pivot Table Customize functions in the Data Field | Excel Discussion (Misc queries) | |||
Advise on Pivot Table & Functions | Excel Discussion (Misc queries) |