Thread: Pull Pivot Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Pull Pivot Data

I have a pivot table that gets it's data from an Access database (it has
65,536 records). Is there a way to make a call to specific variables in

this pivot table? For example, if I have a variable called AGE in this pivot
table and I would like to use a formula:

=PERCENTILE(AGE,.99)

To get the 99th percentile of Age in this pivot table. Is there a way to do
this?
Thanks.