Prev: Data moving 3
Next: Saving information to PERSONAL.XLS
From: Venkataramana on 7 Apr 2010 08:20
HI,
I am working on pivot table for data analysis, where I need to show the
median. While working on this I found that "Median" is not supported in
pivot tables. Is there any way I can use median function in pivot tables?

Best Regards,
Venkataramana
From: ryguy7272 on 7 Apr 2010 11:25
AFAIK, you can't alter pivot tables, but you can certainly copy/paste special
(perhaps a new sheet), and then do whatever you want to it (perhaps in an
adjacent column).


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Venkataramana" wrote:

> HI,
> I am working on pivot table for data analysis, where I need to show the
> median. While working on this I found that "Median" is not supported in
> pivot tables. Is there any way I can use median function in pivot tables?
>
> Best Regards,
> Venkataramana
 | 
Pages: 1
Prev: Data moving 3
Next: Saving information to PERSONAL.XLS