+ Reply to Thread
Results 1 to 3 of 3

Help with summarizing data

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    Troy, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    15

    Help with summarizing data

    Please see attached. We currently have a spreadsheet that we use for monthly projections based on client. We are a healthcare business, so we have billing date, expected receipt date, etc. What we are trying to do is take the projected receipt date and expected amount for each client and put it on a summary tab and then sort by oldest date to newest date in order to know when cash will be coming in.

    If you see on the attached worksheet, I tried to do a pivot table to summarize the data I want, which I would do for each of the client tabs, but I am wondering how do I summarize the data on another tab? Would I have to link it or should I make the pivot table on another tab, etc. Please help. This is a problem that I have not been able to solve and it is creating a lot of manual work. Thank you. Any input would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Help with summarizing data

    Hi, move the pivot table to another sheet, Go to Pivot Tables>Analyse>Move PT, select the new sheet
    Click just below left if it helps, Boo?ath?

  3. #3
    Registered User
    Join Date
    07-25-2013
    Location
    Troy, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Help with summarizing data

    If I move the pivot table(s) for each client, will I then be able to sort by date "expected receipt date" for all clients (separate pivot tables for each)?

+ 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. Need some help with summarizing data...
    By vkeller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2012, 11:56 AM
  2. Summarizing Data
    By C90RanMan in forum Excel General
    Replies: 11
    Last Post: 06-10-2010, 02:30 PM
  3. Summarizing data
    By dallymo in forum Excel General
    Replies: 7
    Last Post: 01-22-2010, 11:38 AM
  4. Summarizing raw data
    By sonyap in forum Excel General
    Replies: 3
    Last Post: 10-29-2009, 07:38 AM
  5. Need help with summarizing data
    By Cathy in forum Excel General
    Replies: 3
    Last Post: 10-20-2005, 04:05 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