[Issue 125860] New: Pivot tables, adding a data field twice - Enhancement

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125860

          Issue ID: 125860
        Issue Type: ENHANCEMENT
           Summary: Pivot tables, adding a data field twice - Enhancement
           Product: Calc
           Version: 4.1.1
          Hardware: PC
                OS: Linux64
            Status: UNCONFIRMED
          Severity: major
          Priority: P2
         Component: ui
          Assignee: issues@openoffice.apache.org
          Reporter: michael.feehilly@ie.ibm.com

Created attachment 84194
  --> https://issues.apache.org/ooo/attachment.cgi?id=84194&action=edit
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
http://www.skilledup.com/articles/10-he ... 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
http://office.microsoft.com/en-ie/train ... section=10
click to go to the next page
http://office.microsoft.com/en-ie/train ... section=11
http://office.microsoft.com/en-ie/train ... section=12
http://office.microsoft.com/en-ie/train ... section=13
http://office.microsoft.com/en-ie/train ... 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
http://office.microsoft.com/en-ie/train ... 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
http://office.microsoft.com/en-ie/train ... 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
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=73506 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 -
https://issues.apache.org/ooo/show_bug.cgi?id=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"


Thanks
Michael

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.