Results 1 to 4 of 4

Thread: How to edit Excel Pivot Table Layout

  1. #1
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,376
    Thanks
    35
    Thanked 393 Times in 340 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:	74 
Size:	40.2 KB 
ID:	6070  
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "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
    26
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,376
    Thanks
    35
    Thanked 393 Times in 340 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "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
    26
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Pleasure! Glad we could you for a change

Similar Threads

  1. [Question] IRP 5 edit and reissue
    By StephanieB in forum Accounting Forum
    Replies: 9
    Last Post: 09-Nov-15, 10:30 AM
  2. pastel tabs - no access to EDIT, PROCESS
    By tlargier in forum Accounting Forum
    Replies: 3
    Last Post: 30-Jun-15, 06:57 PM
  3. SNT STANDARD TABLE TENNIS TABLE
    By Singhms 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
  •