Use of Array Pivot Table for Percentile Calculation ...

G

Guest

Hi,

I've created a Pivot table from a sheet of 500 rows of data and would like
to add 4 different percentile calculations based on the pivot table results.
I would however want the array of the pivot table result (and not the result
itself) to be used for calculation.

Any help out there ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentile() On Pivot Table 1
Pivot table calculated field 2
Average of Subtotals in Pivot Table 0
Pre-configuring Pivot table "views" 4
Whats wrong with this array formula 7
Auto insert of a pivot table? 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Workbook pivot table design function 6

Top