Pivot Table - Arbitrary Sort
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Pivot Table - Arbitrary Sort

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Chicago, IL USA
    Posts
    306
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there any way to add a secondary rank that would order the values within a group without creating more groups and subtotals?

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-20 06:10, Adrae wrote:
    Is there any way to add a secondary rank that would order the values within a group without creating more groups and subtotals?

    Thanks
    Care to provide a simple example using less than 10 data list records? Please specify your desired result.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Chicago, IL USA
    Posts
    306
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I did an example in excel, but don't know how to attach it. Anyway, let me see if I can explain:

    Here's the sample source data:
    rank order Item Amount
    1 2 Example 1 100.00
    1 1 Example 2 100.00
    1 4 Example 3 100.00
    1 3 Example 4 100.00
    1 5 Example 5 100.00
    2 5 Example 6 100.00
    2 4 Example 7 100.00
    2 1 Example 8 100.00
    2 2 Example 9 100.00
    2 3 Example 10 100.00

    Here's how I want it to appear:
    Total
    1 Example 2 100
    Example 1 100
    Example 4 100
    Example 3 100
    Example 5 100
    1 Total 500
    2 Example 8 100
    Example 9 100
    Example 10 100
    Example 7 100
    Example 6 100
    2 Total 500
    Grand Total 1000

    I wasn't able to include all the borders to make it look more like an actual pivot table, but you get the idea. Notice how it sorts the individual examples within each group (1 & 2) according to the order but without adding subtotals. Can this be done?
    Thanks

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-02-20 07:16, Adrae wrote:
    I did an example in excel, but don't know how to attach it. Anyway, let me see if I can explain:

    Here's the sample source data:
    rank order Item Amount
    1 2 Example 1 100.00
    1 1 Example 2 100.00
    1 4 Example 3 100.00
    1 3 Example 4 100.00
    1 5 Example 5 100.00
    2 5 Example 6 100.00
    2 4 Example 7 100.00
    2 1 Example 8 100.00
    2 2 Example 9 100.00
    2 3 Example 10 100.00

    Here's how I want it to appear:
    Total
    1 Example 2 100
    Example 1 100
    Example 4 100
    Example 3 100
    Example 5 100
    1 Total 500
    2 Example 8 100
    Example 9 100
    Example 10 100
    Example 7 100
    Example 6 100
    2 Total 500
    Grand Total 1000

    I wasn't able to include all the borders to make it look more like an actual pivot table, but you get the idea. Notice how it sorts the individual examples within each group (1 & 2) according to the order but without adding subtotals. Can this be done?
    Thanks
    Make your ROW area fields: 'rank', 'order',
    'Item' (in this order). Double-click the
    'order' field button and set its Subtotals
    to "None". If desired hide the column
    containing the 'order' field.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com