Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull data from different worksheets/tab into one Pivot Table MMangen Excel Worksheet Functions 3 August 4th 09 05:36 AM
pivot table pull down filter Sanj Excel Worksheet Functions 1 September 8th 06 02:32 AM
Pull Pivot Table Data Dave Excel Discussion (Misc queries) 0 May 23rd 06 03:11 PM
Pull pivot table data Dave Excel Discussion (Misc queries) 1 May 20th 06 01:01 AM
Can a Pivot Table pull data from Multiple WorkSheets ? GSears Excel Programming 1 May 24th 04 02:39 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"