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:
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:
Do notice the comment about the bug in the algorithm and its fix.
Must be function for pivot being:
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.