ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pull Pivot Table Data (https://www.excelbanter.com/excel-discussion-misc-queries/90063-pull-pivot-table-data.html)

Dave

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.



All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com