Bug 61700 - PIVOTTABLE: Median and other functions in pivot table data fields
Summary: PIVOTTABLE: Median and other functions in pivot table data fields
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
Reported: 2013-03-02 17:38 UTC by krajcsi
Modified: 2016-11-27 11:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description krajcsi 2013-03-02 17:38:32 UTC
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.
Comment 1 A (Andy) 2013-04-09 20:43:27 UTC
marked as enhancement request
Comment 2 David Filiatrault 2014-08-25 00:08:36 UTC
Also want to see PERCENTILE and PERCENTRANK options
Comment 3 Tamás Zolnai 2016-11-20 11:56:07 UTC
Median is added to pivot table functions:

It will be available in LibreOffice 5.3.
Comment 4 Phil 2016-11-27 11:49:28 UTC
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.