jsparrow22
New Member
- Joined
- Feb 3, 2023
- Messages
- 4
- Office Version
- 2013
- Platform
- Windows
I am using the percentile.exc formula to display the 50th, 85th and 95th percentile.
This figure is calculated from a column containing days items take to complete. The days items take to complete contains data for multiple categories but when I filter the categories I continue to get the same percentile result.
What formula do I need to ensure the percentile is adjusted based on whichever category of item I am interested in.
I still want an overall view but being able to have the data per category would be beneficial.
Thanks in advance.
This figure is calculated from a column containing days items take to complete. The days items take to complete contains data for multiple categories but when I filter the categories I continue to get the same percentile result.
What formula do I need to ensure the percentile is adjusted based on whichever category of item I am interested in.
I still want an overall view but being able to have the data per category would be beneficial.
Thanks in advance.