| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Function for Pivot Table
Is it possible to attach a customized function to a field calculation in a
pivot table? For example, if instead of AVERAGE I want WTDAVG, I would write a function for WTDAVG and it would show up as a choice in the available functions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom Function for Pivot Table
I don't think Pivot tables work like that, but I could be wrong. Anyway, why
don't you do this outside of the Pivot Table. Create a helper column for your weighted average and do the calculation there. Do a little research on the Getpivotdata function: http://office.microsoft.com/en-us/ex...091071033.aspx -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Stratuser" wrote: Is it possible to attach a customized function to a field calculation in a pivot table? For example, if instead of AVERAGE I want WTDAVG, I would write a function for WTDAVG and it would show up as a choice in the available functions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom field with custom formula in pivot table! | Excel Worksheet Functions | |||
| PIVOT TABLE CUSTOM FIELD | Excel Discussion (Misc queries) | |||
| Custom Formula in Pivot Table Row | Charts and Charting in Excel | |||
| Pivot Table - Custom Formatting | Excel Programming | |||
| Pivot Table Custom Calculations | Excel Discussion (Misc queries) | |||
Linear Mode
