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,
 

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

Back
Top