+ Reply to Thread
Results 1 to 1 of 1

Consolidated Pivot headache - can't get the same fields with Pivot Table Wizard

  1. #1
    Registered User
    Join Date
    01-09-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    22

    Consolidated Pivot headache - can't get the same fields with Pivot Table Wizard

    This is my data: http://screencast.com/t/hTmzP2I5g4y0

    It is simply expense from two sources: my checking account, and a Visa credit card.

    My goal is to show the total for each category (this is the row), by month.

    I have two pivot tables.

    1. First one is CHECKING ONLY. This is made using a regular pivot table.
    2. Second one is CHECKING & VISA. This is made using the Pivot Table Wizard for consolidated pivot tables.

    My goal is to make the second pivot table like the first.

    As you can see, why do I have field within fields: http://screencast.com/t/IrDxwLOG75b

    I have also attached this file.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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