Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2001
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PivotTable Row Fields (2003)

    Dear Friends,
    I attach a file that self-explains the result I need. I need the pivotTable to fill in ALL the outer row cells for grouped row fields. The reason: I insert formulas eg. STDEV beyond and to the right of the table. Then freeze the window pane. Upon ScrollRight, I cannot see Col1 row field value if it has been grouped as it appears only once above. Thank you. (Searched through HELP and various menus, no joy.). Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PivotTable Row Fields (2003)

    You can't do this with a pivot table, I'm afraid. You could copy the pivot table and paste it as values in another location, then run a macro to fill in the missing values. Theres are examples of such macros in this forum. But you would have to repeat these steps each time the pivot table is refreshed or modified...

  3. #3
    Lounger
    Join Date
    Dec 2001
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PivotTable Row Fields (2003)

    Thank you HansV for confirming it cannot be done through a menu selection. Saves a lot of search time. Selva.

Posting Permissions

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