Results 1 to 2 of 2

Thread: Pivot Table

  1. #1
    New Lounger
    Join Date
    Nov 2008
    Location
    Winchester, Hampshire, United Kingdom
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy

    Excel 2007

    I'm tackling pivot tables with mixed results so far! I am trying to add a comment cell which will display alongside the date. The pivot table is sorting by comment as well as date, which makes the display messy and harder to follow. For example, on the attached sample worksheet, pivot table (sheet 6) cell A6 is the date, while A7 is the comment. I want to get the comment into B6 (and therefore move everything else along one col) so the comment displays alongside the date, but can't work out how to do this, though I'm sure there must be a awy. I've tried editing sort options but nothing I've done makes any difference, apart from removing the comment altogether.
    Help!

    thanks


    Rick
    Attached Files Attached Files

  2. #2
    New Lounger
    Join Date
    Nov 2008
    Location
    Winchester, Hampshire, United Kingdom
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I've moved on a bit on this - by changing the design it does show the comment alongside the date; however it then loses the subtotal for each client - so the question then becomes Can I still have subtotals for each client on this design? Basically I want my cake and eat it...

    thanks

Posting Permissions

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