Percentile() On Pivot Table

A

acces

Hi all,
is there any possibility how to compute percentile() on a pivot table?.
I know that I can use array formulas but my pivot table is based on
external data. If you know that it isn't possible, pls let me know.
Regards,
Tomas
 
G

Guest

In the Pivot Table Data area, right-click, select 'Field Settings...',
left-click on 'Options>>', select the appropriate 'Show Data as:' and see if
there's anything there you can use.

HTH,
 

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

Use of Array Pivot Table for Percentile Calculation ... 0
Pivot table calculated field 2
PERCENTILE exceeding 8191 points 1
Ignore Zero's - Percentile 2
Percentile on Aggregate data with multiple criteria 0
Pivot table data source 1
Average of Subtotals in Pivot Table 0
Use excel to calculate a percentile from data in multiple sheets 0

Top