Issue 89477 - calculated field in datapilot
Summary: calculated field in datapilot
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 125861 (view as issue list)
Depends on:
Reported: 2008-05-14 18:55 UTC by ddmicrolog
Modified: 2016-10-22 09:03 UTC (History)
6 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Simulated datapilot (14.20 KB, application/vnd.sun.xml.calc)
2008-05-14 18:56 UTC, ddmicrolog
no flags Details
Microsoft Excel example (12.50 KB, application/
2008-05-14 19:00 UTC, ddmicrolog
no flags Details
Facked dataPilot editor window (30.62 KB, image/png)
2008-05-14 19:01 UTC, ddmicrolog
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ddmicrolog 2008-05-14 18:55:02 UTC
In my datapilot, I need to compute a weighted average and to do that I need to
use a calculated field like "sum(field1) / sum(field2)" where field1 and field2
are columns in datasource

In attachement you will find a simulated datapilot in the ods file and a
screenshoot of formula in the datapilot editor window

Comment 1 ddmicrolog 2008-05-14 18:56:11 UTC
Created attachment 53634 [details]
Simulated datapilot
Comment 2 ddmicrolog 2008-05-14 19:00:21 UTC
Created attachment 53635 [details]
Microsoft Excel example
Comment 3 ddmicrolog 2008-05-14 19:01:07 UTC
Created attachment 53636 [details]
Facked dataPilot editor window
Comment 4 oc 2008-07-15 10:45:09 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)
Comment 5 david.amonou 2013-10-18 12:08:59 UTC
it is a very important feature missing and benefit pilot data is greatly reduced.
Comment 6 Edwin Sharp 2013-12-25 16:00:09 UTC
Useful feature for Pivot Table.
Comment 7 oooforum (fr) 2014-11-17 10:38:41 UTC
*** Issue 125861 has been marked as a duplicate of this issue. ***
Comment 8 atonx88 2015-04-24 14:46:59 UTC
For me, it forced me to give up this time replacing Excel. For users who do business in management control is an indispensable function.
And as it is not reasonable to have two office tools within the same organization, we are subject to Microsoft ...
Comment 9 pascal.bry 2016-10-22 09:03:24 UTC
Please fix this issue (possibility to define some proprietary formula in new field, at least using fields from database), available in excel..... and very useful for pivot table.