Bug 78486 - Feature Request: Add Calculated Field in PIVOT TABLE
Summary: Feature Request: Add Calculated Field in PIVOT TABLE
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 126858 127380 (view as bug list)
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
Reported: 2014-05-09 12:47 UTC by Copeliner
Modified: 2023-04-30 18:51 UTC (History)
20 users (show)

See Also:
Crash report or crash signature:

Calculated Field Example and Design Suggestion (55.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-12-02 15:27 UTC, Kevin Suo

Note You need to log in before you can comment on or make changes to this bug.
Description Copeliner 2014-05-09 12:47:03 UTC
We warmly welcome,

Please help in adding to LibreOffice 4.3 or subsequent versions such thing as a calculated field in a PivotTable.
How and to whom would pull such a request, on a forum written something about masters Kohei Yoshida Markus Mohrhard or whether it is the right person?
I am really missing the functionality that exists in Office, basically I have a feeling that this area is a little less developed.
For any information in advance thank you very much.
Comment 1 Kevin Suo 2014-05-31 15:56:45 UTC
You should not mark your own bug as new, as it needs further investigate.

Comment 2 Jacques Guilleron 2014-06-09 13:18:44 UTC
Hi Copeliner,

I see the lack and set importance for this report as enhanbcement and Platform to All.


Comment 3 Calc_addict 2015-01-30 15:11:41 UTC

I am also really missing the functionnality "calculated field" in a pivot table.
I am using Excel a lot at the office, and each time I build a pivot table (on big data files), I add many calculated fields. It is versatile, easy to use and make the pivot table a more powerful calculating tool.
Now, I have to switch to LO and I really appreciate working with Calc except that I can not add any calculated field in the pivot table. I have to add columns outside the pivot table to let perform the calculations that should be done inside it. This way, this specific tool is less powerfull and flexible.
I have searched a lot on forums but did not find any solution.

Is there an extension available to add this functionnality for the pivot tables or would it be possible that someone develops such an extension?

Thanks a lot,
Comment 4 Calc_addict 2015-01-30 15:13:02 UTC Comment hidden (obsolete)
Comment 5 Vincent 2016-01-19 09:38:11 UTC

I also would really like this functionality implemented.
Is there a way to vote this up?
The GETPIVOTDATA function does not what I need (or I am unable to use it) and a suggestion at the question list for manipulating the data before the pivot table is made does not work either.

A simple calculated field works, but does not move with an changed of the pivot table.

I have asked the question here:

Still not available in LibreOffice 5.
I would be happy to contribute in anyway on request.
At this point setting up a development environment maybe a step to far, but I am willing to try with the proper help.

thank you
Comment 6 Kevin Suo 2016-12-01 11:27:22 UTC
Changed title summary and added to "Pivot-Table" meta bug.
Comment 7 Cor Nouws 2016-12-02 13:52:48 UTC
So that should be in addition to what currently is offered in the dialog "Data Field" that opens when one double clicks a data field in the layout part of the design window?
Comment 8 Kevin Suo 2016-12-02 15:27:32 UTC
Created attachment 129252 [details]
Calculated Field Example and Design Suggestion

I have prepared the attached example spreadsheet file to show what a calculated field is. 
I also suggested a simple layout of the dialogs.
Comment 9 Kevin Suo 2016-12-02 15:29:12 UTC
(In reply to Kevin Suo from comment #8)
Anyone who is interested in this feature please complement the design suggestion.
Comment 10 simone 2017-10-20 21:28:53 UTC
Hi to all,
I thinks it's necessary the functionality "calculated field" in a pivot table.
How can we do to suggest to do this funcionality to developers?

Other functionality in pivot ( less import) are the different layout of pivot, like you can do in Excel.

Comment 11 carles 2017-11-29 09:11:48 UTC

I also think that a new functionality to create a "calculated field" in a pivot table will be very useful.

I think it's a great suggestion to developers.

Thanks a lot,
Comment 12 Phil 2019-05-31 09:02:43 UTC
It'll be regretful that one can compute a discrete Fourier transform in the upcoming LO 6.3 (tdf 74664), but not a simple weight of a field in a pivot table (example salesValues/sum of sales Values)

Consider seeing:

Additionnaly, I do not see this MAJOR missing feature reported in https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_Microsoft_Office

P.S. This functionality already exist in Excel 2000
Comment 13 Phil 2019-05-31 09:06:30 UTC
Assignee: none so far
target: no LO release plan
Comment 14 m.a.riosv 2019-08-12 22:25:22 UTC
*** Bug 126858 has been marked as a duplicate of this bug. ***
Comment 15 m.a.riosv 2019-09-05 21:52:01 UTC
*** Bug 127380 has been marked as a duplicate of this bug. ***
Comment 16 m.a.riosv 2019-09-05 21:53:11 UTC
*** Bug 126858 has been marked as a duplicate of this bug. ***
Comment 17 johnks 2020-07-20 16:59:53 UTC
any updates on this 6 year old bug report?
Comment 18 Armando Soto Baeza 2022-02-06 19:33:32 UTC
I think it is an important enhancement.
Comment 19 Acroneuria 2022-07-25 16:19:42 UTC
I would also like to see this feature. (I'm just a user, not a developer.)
Comment 20 Biz Infograph 2023-02-03 12:40:47 UTC Comment hidden (spam)
Comment 21 syednizamudeen@gmail.com 2023-04-10 16:57:58 UTC
20 People have reported for this enhancement so far. Why hasn't the status still in New? Devs please look into this enhancement. Adding a Calculated field to the pivot table exist in Microsoft Excel for several years. Please implement.