Issue 72304 - DataPilot : sorting by dataField
Summary: DataPilot : sorting by dataField
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: usability
Depends on:
Blocks:
 
Reported: 2006-12-05 20:12 UTC by pagalmes.lists
Modified: 2013-02-07 22:42 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
the file with the example (10.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-12-05 20:13 UTC, pagalmes.lists 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.