Percentile() On Pivot Table

  • Thread starter Thread starter acces
  • Start date Start date
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
 
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,
 
Back
Top