Results 1 to 5 of 5
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Outline Data (2000)

    I'm wanting some idea on the best way to organise data on a single sheet (see attachment, Sheet 1). The data records are unnormalized, containing a repeating group. The most important data items are the "Payment" fields within the repeating groups. The repeating groups correspond to designated areas - Area1, Area2, ...

    My thought was to try to outline the (column) data and have each Area collapse down so that only the Payment field is visible. They could then be expanded as needed to see the details. I can't achieve this result - only collapse the whole of the groups down to nothing. I thought I'd seen some other XL feature used before to show such data in this manner. I'd like to know some of the possibilities here. For instance, are pivot tables of any relevance?

    Any ideas appreciated.

    Alan

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outline Data (2000)

    You will have to remove the merged cells before you can use data outlining on the columns.
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outline Data (2000)

    I have unmerged the cells, but this still does not help with the behaviour I have described (the effect appears to be the same in fact). The problem/limitation using Outline, as far as I can see, is that the entire selection of columns collapses down to nothing, rather than showing just a single column, which is the effect I'd be after.

    Alan

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Outline Data (2000)

    Is this what you are after?
    I moved the PAYMENTS to the end of the "area" and ONLY grouped on the OTHER 4 columns of each area. By NOT grouping the Payments they do NOT collapse and by putting them at the end, the "+" sign is above the appropriate column to expand.

    Steve

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outline Data (2000)

    Far too simple - decidedly uncomfortable with a solution like this! <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Yes, thanks Steve - that will do the trick here. It would seem I couldn't see the forest for the trees. I guess, with the appropriate planning, that general method could be extended to several repeating groups, even nested groups perhaps. ??? Still, I was sure I'd seen a complete method described for the presentation of "non-flat" data in a highly readable format. It may have involved using several of the top rows and left columns for field names at various levels. Ring any bells?

    thanks

    Alan

Posting Permissions

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