View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave
 
Posts: n/a
Default Pull pivot table 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.