+ Reply to Thread
Results 1 to 2 of 2

Pvit table running totals from multiple data sources

  1. #1
    Registered User
    Join Date
    09-05-2011
    Location
    Ryther, England
    MS-Off Ver
    Office 365
    Posts
    63

    Pvit table running totals from multiple data sources

    Hi guys

    I'm am attempting to create a pivot table using multiple data sources. Each data source is the same type of data. What I need to do is create one pivot table to do a running total of each data source column. As an example I have a data table named January where I have a column titled number of new students. I also have the same column title for a data table named February. What I need the pivot to do is do a total of January's number of new students with February's.

    is this achievable? I've attached a sample spreadsheet for info.

    Thanks in anticipation of any help.

    Regards

    mac
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Pvit table running totals from multiple data sources

    Why not use SumIF function?
    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)

Similar Threads

  1. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  2. Replies: 0
    Last Post: 06-14-2013, 07:05 AM
  3. VBA Pivot Table - Multiple Tables - Multiple Sources of Data
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 03:13 PM
  4. Replies: 1
    Last Post: 03-08-2012, 05:36 PM
  5. Need to combine multiple data sources for pivot table [MDX query?]
    By needsomehelp3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2011, 04:32 PM

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