[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

URL||https://ask.libreoffice.org
   ||/t/calculated-fields-in-a-p
   ||ivot-table/16648

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #22 from jin...@immerda.ch ---
Hi, I just wanted to say I also find this feature important and would like it
implemented (as a user).

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #21 from syednizamud...@gmail.com  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #20 from Biz Infograph  ---
Calculate Range in Excel

Calculate Range in Excel is a crucial function that helps determine the
difference between the highest and lowest values in a data set. This tool helps
in analyzing and organizing data in a spreadsheet by finding the range of
values in a range of cells. The range calculation is easy to perform in Excel,
and it's an essential tool for data analysis. Get step-by-step instructions on
how to calculate range in Excel at bizinfograph.com. 
Visit: https://www.bizinfograph.com/resource/how-to-find-range-in-excel/

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #19 from Acroneuria  ---
I would also like to see this feature. (I'm just a user, not a developer.)

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #18 from Armando Soto Baeza  ---
I think it is an important enhancement.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #17 from johnks  ---
any updates on this 6 year old bug report?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #16 from m.a.riosv  ---
*** Bug 126858 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

m.a.riosv  changed:

   What|Removed |Added

 CC||msyl...@gmail.com

--- Comment #15 from m.a.riosv  ---
*** Bug 127380 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

m.a.riosv  changed:

   What|Removed |Added

 CC||79045_79...@mail.ru

--- Comment #14 from m.a.riosv  ---
*** Bug 126858 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

raal  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||6858

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #13 from Phil  ---
Notice:
Assignee: none so far
target: no LO release plan

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #12 from Phil  ---
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:
https://www.youtube.com/watch?v=cTl3rPLP1cE
or
https://www.excelcampus.com/pivot-tables/average-daily-total-calculation/


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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #11 from car...@escila.net ---
Hi,

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,

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #10 from simone  ---
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.

Thanks
simone

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #9 from Kevin Suo  ---
(In reply to Kevin Suo from comment #8)
Anyone who is interested in this feature please complement the design
suggestion.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

--- Comment #8 from Kevin Suo  ---
Created attachment 129252
  --> https://bugs.documentfoundation.org/attachment.cgi?id=129252=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl

--- Comment #7 from Cor Nouws  ---
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?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78486] Feature Request: Add Calculated Field in PIVOT TABLE

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=78486

Kevin Suo  changed:

   What|Removed |Added

Version|4.3.0.0.alpha1  |Inherited From OOo
 Blocks||103381
Summary|LibreOffice 4.3 PIVOT TABLE |Feature Request: Add
   |-calculated field   |Calculated Field in PIVOT
   ||TABLE
 OS|Windows (All)   |All

--- Comment #6 from Kevin Suo  ---
Changed title summary and added to "Pivot-Table" meta bug.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103381
[Bug 103381] [META] Pivot table (aka Data Pilot) bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs