Hi all,
is there any possibility how to compute percentile() on a pivot table?. I know that I can use array formulas but my pivot table is based on external data. If you know that it isn't possible, pls let me know.
Regards,
Tomas
Hi all,
is there any possibility how to compute percentile() on a pivot table?. I know that I can use array formulas but my pivot table is based on external data. If you know that it isn't possible, pls let me know.
Regards,
Tomas
In the Pivot Table Data area, right-click, select 'Field Settings...',
left-click on 'Options>>', select the appropriate 'Show Data as:' and see if
there's anything there you can use.
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
"acces" wrote:
>
> Hi all,
> is there any possibility how to compute percentile() on a pivot table?.
> I know that I can use array formulas but my pivot table is based on
> external data. If you know that it isn't possible, pls let me know.
> Regards,
> Tomas
>
>
> --
> acces
> ------------------------------------------------------------------------
> acces's Profile: http://www.excelforum.com/member.php...fo&userid=4980
> View this thread: http://www.excelforum.com/showthread...hreadid=522123
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks