In pivot table several functions are available for the data fields. Still, the list of available functions are limited. Median function could be a useful addition. More generally, custom functions would be useful for many users.
marked as enhancement request
Also want to see PERCENTILE and PERCENTRANK options
Median is added to pivot table functions: https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=99dbbecb1c0838494b095e8338dc7e6b00ab2cb6..92c1128fb80b4e38df219ce60f018cfb1522b20a It will be available in LibreOffice 5.3.
Thanks very much for at last implementing functions for pivot table. Now, regarding implementation of percentile (and in particular median, quartiles), see algorithm: http://stackoverflow.com/questions/2374640/how-do-i-calculate-percentiles-with-python-numpy Do notice the comment about the bug in the algorithm and its fix. Must be function for pivot being: sum count counta(non empty cell count) and normal descriptive stat: min, max, average, variance, percentile. I also seize the opportunity to also mention that in the User Interface it's disturbing to have one side the menu "Insert>Pivot table" in order to create it and "Data\Pivot table" on the other to delete or refresh it; all belong to context of pivot table and UI must reflect this.
See also: * http://stackoverflow.com/questions/3738349/fast-algorithm-for-repeated-calculation-of-percentile * https://en.wikipedia.org/wiki/Selection_algorithm#Selecting_k_smallest_or_largest_elements