Re: Sorting Grouped Dates in Pivot Table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 05/05/04 

Date: Wed, 05 May 2004 07:25:28 -0400

The date range is a text string, and 4/26 comes before 4/5 when sorted
alphabetically.

You could ungroup the dates, sort, then regroup them, and the order
should be correct.

Gio Bacareza wrote:
> Having problems sorting grouped dates in a pivot table report. I have a
> column filled with dates. I run pivot table and sort the dates in ascending
> order. Everything's fine. Then I group the dates by 7 days (since there's no
> automatic weekly grouping.) The resulting pivot table have a weird sorting:
>
> 3/29/2004 - 4/4/2004
> 4/12/2004 - 4/18/2004
> 4/19/2004 - 4/25/2004
> 4/26/2004 - 5/2/2004
> 4/5/2004 - 4/11/2004
> 5/3/2004 - 5/9/2004
>
> I have made sure that all the other visible fields (page and column) have no
> sorting order. 

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Relevant Pages

  • Re: In which cases/problems is Prolog faster than Java?
    ... The overhead for parallelism can be prohibitive for small datasets, but once we get to sorting datasets that have a size ... comment is 'Multi-threaded version of the quick sort algorithm.', ... partition(Rest, Pivot, Smaller0, Bigger0), ... qsort(Bigger0, Acc, Bigger, Threads2) ...
    (comp.lang.prolog)
  • Re: sorting columns
    ... I wanted to make sure i was not missing some internal functions to help me ... Pivot tables are more like ... If you plan on creating your custom sort code, ... First, if you ever had a course on programming dealing with sorting, ...
    (microsoft.public.excel.programming)
  • Re: sorting columns
    ... Pivot tables are more like Cross ... If you plan on creating your custom sort code, you many want to think about ... First, if you ever had a course on programming dealing with sorting, there's ... sort objects within sort objects to create you different layers of sort ...
    (microsoft.public.excel.programming)
  • Re: Pivot Table - Grouped Dates - Format
    ... If you sort them later, ... I have a grouped pivot by date. ... the date doesn't allow sorting in the way that I need. ... the pivot and it doesn't do anything at all to how the format in the ...
    (microsoft.public.excel)
  • Re: A Fast sorting algorithm for almost sorted data
    ... far my compressor has potential but is nowhere near ready. ... It does however make heavy use of sorting. ... which I am currently calling Run sort. ... entire selected run can be added to the sorted output array. ...
    (comp.compression)