N
Neanderthal
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
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