Results 1 to 4 of 4

Thread: How to edit Excel Pivot Table Layout

Threaded View

Previous Post Previous Post   Next Post Next Post
  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)

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
  •