ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot Table Calculations (https://www.excelbanter.com/excel-worksheet-functions/197087-pivot-table-calculations.html)

Neanderthal

Pivot Table Calculations
 
I need to calculate the Percentile of the data fields of a PivotTable in
Excel. My PivotTable is constructed from columns called Region, Category,
Month and Resolution in Days. I want to do this calculation on the Resolution
in Days value after it is filtered to one or more of each of Region, Category
and Month. I have tried to create a column in the original table, but would
need a function like Daverage but for percentile(DPercentile) to calculate
only the range of data I want. If anyone has either solution, how to
calculate Percentile inside of a PivotTable cell or how to perform a
DPercentile in a normal Excel worksheet, please reply to this post. I will
try to paste a picture of my PivotTable below.

Region AGR-AGRICULTURE

Count of Resolved in Days Column Labels
Row Labels Hardware Network Security Software
Jan 08 33 1 23 70
Feb 08 44 7 34 53
Mar 08 46 3 32 62
Apr 08 61 6 23 57
May 08 38 5 30 57
Jun 08 60 3 35 72
Jul 08 37 2 26 57

Thank you



All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com