Results 1 to 5 of 5

Pivot table issue (doesn't come out as planned)

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2008
    Location
    Hallandale
    Posts
    44

    Pivot table issue (doesn't come out as planned)

    I知 doing a simple pivot table and I知 having a problem with layout:
    I have 3 items that I知 working with:

    Date
    Debit
    Credit

    When I知 done it looks like this:

    DATE Data Total
    8/31/2008 Sum of Debit 736957.94
    Sum of Credit 52090
    9/1/2008 Sum of Debit 1024098.06
    Sum of Credit 65754.65
    9/2/2008 Sum of Debit 2410519.64
    Sum of Credit 344438.31

    It should look like this:

    Data
    DATE Sum of Debit Sum of Credit
    8/31/2008 736957.94 52090
    9/1/2008 1024098.06 65754.65
    9/2/2008 2410519.64 344438.31



    I know I can move it once I'm done but I need it to come out as the right away as the last example.

    What am I doing wrong ?
    Attached Files Attached Files
    Last edited by koklok; 10-08-2008 at 04:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table - Few complicated queries
    By acsishere in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2008, 05:08 PM
  2. Critical PIVOT TABLE issue
    By ONB in forum Excel General
    Replies: 0
    Last Post: 03-27-2008, 09:41 AM
  3. Pivot table issue
    By moyemrick in forum Excel General
    Replies: 1
    Last Post: 08-23-2007, 04:18 PM
  4. Can noone help with this pivot table issue?
    By 50pingviner in forum Excel General
    Replies: 1
    Last Post: 09-26-2006, 07:25 AM
  5. Pivot table issue
    By 50pingviner in forum Excel General
    Replies: 0
    Last Post: 09-22-2006, 09:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1