I understand what a percentile is and know about the WebI percentile function.
I need to determine the percentile of a value in a given set.
I have a report that shows the average time spent on a project based on the location of the project. The database has values for all locations. The requirement in to show the average time (a measure) for the selected location but they also want the percentile based on the complete set of times for all locations.
How can I calculate that.
I suspect it may be necessary to calculate it as a universe measure but i don't have control over the universe.