Results 1 to 4 of 4

Thread: How to edit Excel Pivot Table Layout

  1. #1
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts

    How to edit Excel Pivot Table Layout

    I have created a pivot table for a client - see attached screenshot sample.

    The client wants me to change the layout of the pivot table, and I am not sure how to do it.

    For example, row 14 and 15 are extracts from the same document number P4530, but the table reflects the date and supplier name only on the first row, i.e. row 14. My client wants the date and supplier name to repeat on row 15. Another example in the screenshot are rows 16 and 17.

    Any ideas as to how to achieve this?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Pivot Table.jpg 
Views:	254 
Size:	40.2 KB 
ID:	6070  
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  2. #2
    Full Member Jane123's Avatar
    Join Date
    Aug 2015
    Location
    port Elizabeth
    Posts
    27
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Hi Neville... If you right click in blank cell and select "field settings" and the under "layout & print" and then tick the "repeat item labels".... works in a table I use so give it a bash!

  3. #3
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by Jane123 View Post
    Hi Neville... If you right click in blank cell and select "field settings" and the under "layout & print" and then tick the "repeat item labels".... works in a table I use so give it a bash!
    Thank you - works like a treat!
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  4. #4
    Full Member Jane123's Avatar
    Join Date
    Aug 2015
    Location
    port Elizabeth
    Posts
    27
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Pleasure! Glad we could you for a change

Similar Threads

  1. pastel tabs - no access to EDIT, PROCESS
    By tlargier in forum Accounting Forum
    Replies: 5
    Last Post: 16-Oct-18, 05:41 AM
  2. [Question] IRP 5 edit and reissue
    By StephanieB in forum Accounting Forum
    Replies: 9
    Last Post: 09-Nov-15, 10:30 AM
  3. SNT STANDARD TABLE TENNIS TABLE
    By AmithS in forum General Chat Forum
    Replies: 1
    Last Post: 18-Dec-14, 09:56 AM
  4. Edit account number
    By bamani in forum Accounting Forum
    Replies: 3
    Last Post: 28-Nov-13, 04:05 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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