Issue 89477 - calculated field in datapilot
Summary: calculated field in datapilot
Status: CONFIRMED
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:
URL:
Keywords:
: 125861 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-05-14 18:55 UTC by ddmicrolog
Modified: 2016-10-22 09:03 UTC (History)
6 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
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/vnd.ms-excel)
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
Add an attachment (proposed patch, testcase, etc.)

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

Regards
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 requirements@openoffice.org 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.
Thanks