![]() |
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