thaiteaboba
New Member
- Joined
- Aug 24, 2023
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hi there,
I have a pivot table that conveys a column in my data called NET_HOURS, and the pivot table conveys the average of the net hours in one column. I am looking to add a column to my Pivot Table to find the 90 percentile of the net hours. I know I need to create a formula to put as the measure for the new column. I did use the formula "=PERCENTILE.INC(NET_HOURS, .9)" with results looking successful, but the feedback I was getting was that the numbers are still wrong. I am specifically being told to find the average of 90% of the net hours excluding the 10% outliers. I had some other possible functions but they do not seem compatible to use as a measure. Any help would be appreciated!
I have a pivot table that conveys a column in my data called NET_HOURS, and the pivot table conveys the average of the net hours in one column. I am looking to add a column to my Pivot Table to find the 90 percentile of the net hours. I know I need to create a formula to put as the measure for the new column. I did use the formula "=PERCENTILE.INC(NET_HOURS, .9)" with results looking successful, but the feedback I was getting was that the numbers are still wrong. I am specifically being told to find the average of 90% of the net hours excluding the 10% outliers. I had some other possible functions but they do not seem compatible to use as a measure. Any help would be appreciated!