PC Review


Reply
Thread Tools Rate Thread

Custom Function for Pivot Table

 
 
Stratuser
Guest
Posts: n/a
 
      12th May 2010
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 With Quote
 
 
 
 
ryguy7272
Guest
Posts: n/a
 
      12th May 2010
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
slow document / pivot table refresh and pivot function Justin Larson Microsoft Excel Misc 2 14th Oct 2009 01:06 AM
custom field with custom formula in pivot table! Sedaghat Nejad Microsoft Excel Worksheet Functions 2 21st Jun 2009 11:19 AM
Get the pivot information without generiting pivot table - using function J Chokshi Microsoft Excel Discussion 1 18th Mar 2009 07:15 PM
Get Pivot Function - Use of Pivot Table Name bob Microsoft Excel Misc 1 26th Nov 2008 11:23 PM
Custom Views in Pivot Table =?Utf-8?B?U2FtYWQ=?= Microsoft Excel Misc 1 13th Jan 2005 01:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:22 PM.