Issue 72304

Summary: DataPilot : sorting by dataField
Product: Calc Reporter: pagalmes.lists
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: eva-email, issues, ooo
Version: OOo 2.0.4Keywords: usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
the file with the example none

Description pagalmes.lists 2006-12-05 20:12:34 UTC 
Have a look at the sample file. In it, I have a simple dataPilot which
represents some data.

What I would need to do : find which is the "cities" with the most strong
people. So I want to sort the dataPilot result using the number of "yes" as a
sorting criteria.

So the RFE is : adding a way to sort a datapilot using a dataField result as the
sorting criteria.

PS: it would then be nice use a user-defined function as the sorting criteria.
Comment 1 pagalmes.lists 2006-12-05 20:13:41 UTC 
Created attachment 41154 [details]
the file with the example
Comment 2 fsaravia65 2007-08-29 20:05:33 UTC 
   It would be nice to be able to sort both subtotal groups AND data pilot
grids. If I have a datasheet of sales and one column represent the customer, I
would like to be able to make either a subtoal group or a data pilot of sales by
customer, and then sort it to show the main customers first.
Comment 3 oc 2008-07-15 10:43:45 UTC 
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)
Comment 4 Stefan Weigel 2008-09-18 18:41:03 UTC 
Works for me in OOo 2.4.1 as well as in OOo 3.0 RC1

(1) Reopen DataPilot´s dialog
(2) Doubleclick on field "Are you strong?" to see its properties
(3) Click on "Options..."
(4) Choose Hide Items "I don´t know" and "No"
(5) Click "OK", again Click "OK"
(6) Doubleclick on field "City" to see its properties
(7) Click on "Options..."
(8) Choose radio button "Descending"
(9) Choose Sort by "Are you strong ?"
(10) Click "OK" three times
Done. :-)
Comment 5 Mechtilde 2008-11-07 12:18:42 UTC 
close the WORKSFORME issue
Comment 6 pagalmes.lists 2008-11-07 17:04:37 UTC 
Hidin fields is not an option. Thus, this issue should not be closed.
Comment 7 pagalmes.lists 2008-11-07 17:05:22 UTC 
The issue was already new.