Issue 125860 - Pivot tables, adding a data field twice - Enhancement
Summary: Pivot tables, adding a data field twice - Enhancement
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.1
Hardware: PC Linux 64-bit
: P2 Major with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: UKS
Depends on:
Reported: 2014-11-14 17:50 UTC by michael.feehilly
Modified: 2016-02-14 17:08 UTC (History)
1 user (show)

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

Screenshot of sample spreadsheet (53.97 KB, image/png)
2014-11-14 17:50 UTC, michael.feehilly
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description michael.feehilly 2014-11-14 17:50:54 UTC
Created attachment 84194 [details]
Screenshot of sample spreadsheet

Hi Folks,

Really struggling on pivot tables this week

How do I add a field twice as outlined in this article for Microsoft Excel ... able-tips/
scroll down to the section - #8 You can add a field more than once

Another example of adding the field twice, start here ... section=10
click to go to the next page ... section=11 ... section=12 ... section=13 ... section=14
And as mentioned in this last page it shows the report being re-formatted with the additional columne and then it shows how to change it to the percentage ... section=15

Just an aside and not really relevant to this question but for info on another nice feature have a look at page 18 tpo page 21, it shows an example of a calculated field ... section=18

I just don't seem to be able ot do this in my poivot table in OpenOffice.

I want the number of hours in one column in a particular category and the in next column I want to show the perecentage of the total for that row my hrs are.
For example I want to have percentage column between column D and E in the attached screen shot below showing the perentage the weekly total for 1/10/14 for Mgmt Level (17) is of Total Result (39) and I want this automatically update as the data changes/table is refreshed. I want to do the same for the "Non CF" and "Other CF" column.

In addition I would like to do the same for the month result row so for month 1 I would to add a colum with the percentages of the month total.

I would prefer , if instead of columns with the Perecentages, if it would be possible to have rows at the week and month level showing the percentages (this would be my preferred option in this sheet), so where where I have the row "1/10/14 Result" if there was another row beneath that showing percentages for each category subtotal (Mgmt Level, Non CF, Other CF). and again having another row under the month subtotal showing the percentages. I hope I have explained this reasonable well

OpenOffice v4.1.1
AOO411m6(Build:9775) - Rev. 1617669
2014-08-13 09:23 - Linux x86_64

Redhat v6.5
Kernel 2.6.32-43.30.1.el6_x86_64
GNOME 2.28.2

I have posted this question in the user forum at to see if others have found away to achieve this with a sample screenshot of my spreadsheet, also attached below.

I have also read feature request 67443 - which was "closed as not an issue", but even following the instructions there I cannot achieve the % column and the sum of data columns, so would welcome any other recommendations to achieve the same funcationality as show in the video clip - wiht the same data field repeated twice and a different calculation for each instance of the data field.
With the suggestion in 67443, if you make a multi selection of the calculations you want (Sum, Count, max...) in the Data Field dialog window, then when you click "More" you must select the same setting for the "Displayed Value Type" either (Nornal, Difference, %of....) for both calculations, you cannot have one set to "Normal" and the other set to "%of" for example"