Issue 89477

Summary:

calculated field in datapilot

Product:

Calc

Reporter:

ddmicrolog <damien.doiselet>

Component:

editing

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

atonx88, david.amonou, elish, issues, michael.feehilly, pascal.bry

Version:

OOo 2.4.0

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

ENHANCEMENT

Latest Confirmation in:

4.1.0-dev

Developer Difficulty:

---

Attachments:

Description	Flags
Simulated datapilot	none
Microsoft Excel example	none
Facked dataPilot editor window	none

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