nicmichaels
New Member
I need to pivot out the 90th percentile for each country combination.
Example: The raw data shows the number of days different employees are in a country (you read the chart below, “US Citizen spent 7 days in Algeria” and so forth)
US - Algeria 7
US - Algeria 22
US - Algeria 15
US - Algeria 9
US - Algeria 20
Mexico - Finland 112
Mexico - Finland 150
Mexico - Finland 200
Mexico - Finland 99
Mexico – Finland 89
The pivot would show:
US - Algeria 21.2
Mexico - Finland 180
I can get the ranges to dynamically update - I can't seem to find a way to get percentiles into the pivot table. I pull data monthly, about 7,000 lines per month, for over 200 country combinations. Thanks for any help!
Example: The raw data shows the number of days different employees are in a country (you read the chart below, “US Citizen spent 7 days in Algeria” and so forth)
US - Algeria 7
US - Algeria 22
US - Algeria 15
US - Algeria 9
US - Algeria 20
Mexico - Finland 112
Mexico - Finland 150
Mexico - Finland 200
Mexico - Finland 99
Mexico – Finland 89
The pivot would show:
US - Algeria 21.2
Mexico - Finland 180
I can get the ranges to dynamically update - I can't seem to find a way to get percentiles into the pivot table. I pull data monthly, about 7,000 lines per month, for over 200 country combinations. Thanks for any help!
