Issue 116616

Summary: Data Pilot Does Not Allow Multiple of Same Column
Product: Calc Reporter: jmadero <jmadero>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, oliver.brinzing
Version: OOO320m19   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
multiple calculation
none
Data Pilot Type none

Description jmadero 2011-01-25 21:00:06 UTC 
This is a feature request to add the ability to include the same column multiple
times in the "Data Fields" section of the Data Pilot. As of now this is not
allowed and you are forced to choose one method of displaying the data in the
data pilot. Here is a scenario where this would be very helpful:

You have a spreadsheet for expenditures, one column is "category" the other is
"amount". Now you want a data pilot that will 

a. show the total expenditures in each category
b. Show the percent of total which each category represents


Currently this is not possible in data pilot, you'd have to either make two data
pilots or make two columns with identical information and then use one for the
sum, the other for the percent. 

Thank you
Comment 1 Oliver Brinzing 2011-01-26 17:33:29 UTC 
maybe i misunderstood, but multiple selections can 
be done with (strg) + mouse click, here sum, min and average
are calculated

please have a look at the attachment
Comment 2 Oliver Brinzing 2011-01-26 17:34:20 UTC 
Created attachment 75663 [details]
multiple calculation
Comment 3 jmadero 2011-01-26 19:58:38 UTC 
Sometimes....I apologize for wasting your time and thanks for that. Not enough
people use data pilot even though it's so functional so it's hard to get the
information out there -- excellent. Thanks for the hard work
Comment 4 jmadero 2011-01-27 00:55:50 UTC 
I actually was mistaken. This is not what I'm looking for. What I'm looking for
is the following:

Be able to use a single Function but under "Type" use several different types.
I've included a screenshot to show what I'm talking about. In data pilot if you
click on the "more" button, you'll see Displayed Values, so you can choose
multiple functions but not multiple types within a single function (such as
count or sum)
Comment 5 jmadero 2011-01-27 00:56:16 UTC 
Created attachment 75671 [details]
Data Pilot Type
Comment 6 Edwin Sharp 2013-12-28 20:38:17 UTC 
Comment 4 confirmed with
AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Debian