Issue 72304 - DataPilot : sorting by dataField
Summary: DataPilot : sorting by dataField
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:
Keywords: usability
Depends on:
Reported: 2006-12-05 20:12 UTC by pagalmes.lists
Modified: 2013-02-07 22:42 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

the file with the example (10.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-12-05 20:13 UTC, pagalmes.lists
no flags Details

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 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.