Apache OpenOffice (AOO) Bugzilla – Issue 116616
Data Pilot Does Not Allow Multiple of Same Column
Last modified: 2013-12-28 20:38:17 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
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
Created attachment 75663 [details] multiple calculation
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
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)
Created attachment 75671 [details] Data Pilot Type
Comment 4 confirmed with AOO410m1(Build:9750) - Rev. 1551264 2013-12-17_04:10:52 - Rev. 1551455 Debian