+ Reply to Thread
Results 1 to 4 of 4

Summarizing Information in Tables to a Pivot

  1. #1
    Registered User
    Join Date
    04-26-2021
    Location
    Louisiana, USA
    MS-Off Ver
    2019
    Posts
    2

    Summarizing Information in Tables to a Pivot

    Hello All,

    I have a set of data that has 6 main columns: Location, System, Device, Adequate, Inadequate, and Completion Date. Some background information, all devices become complete when the system is complete. There is never a time where only one device within a system is complete.

    What I'm shooting for is a way to pull how many systems are complete? How many systems are Adequate / Inadequate? On the second tab is the way I figured out how to make it work to get the results I want.

    Any help/advice is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    467

    Re: Summarizing Information in Tables to a Pivot

    Is the pivot table not what you need or want? Is there something else you need from this? Seems to do what you need, whats the additional ask?
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

  3. #3
    Registered User
    Join Date
    04-26-2021
    Location
    Louisiana, USA
    MS-Off Ver
    2019
    Posts
    2
    Quote Originally Posted by cubangt View Post
    Is the pivot table not what you need or want? Is there something else you need from this? Seems to do what you need, whats the additional ask?
    Well I would like to be able to do it all within the pivot table without having to pull it outside. My actual data is 1,000s of lines and this method is not so easy.

  4. #4
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    467

    Re: Summarizing Information in Tables to a Pivot

    So you want to basically have your pivot table look like the manual table you have to the right of it?

    I think it can be done using calculated fields in the pivot table..

    Here is an example:
    https://www.excel-easy.com/examples/...ield-item.html

    If i get a few minutes this morning ill play around and see if i can do it.

+ 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. Combining information from multiple tables in a Pivot with Calculations
    By therays97 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-02-2021, 04:53 PM
  2. Replies: 5
    Last Post: 04-16-2020, 02:28 AM
  3. Summarizing information SUF IF and VLOOKUP
    By Anuru in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 05-09-2019, 01:37 AM
  4. Comparing information on 2 different pivot tables
    By ryangodammit in forum Excel General
    Replies: 6
    Last Post: 02-17-2015, 04:09 AM
  5. Replies: 0
    Last Post: 02-07-2015, 01:03 AM
  6. Summarizing with information from multiple columns
    By rooney09 in forum Excel General
    Replies: 1
    Last Post: 08-23-2010, 05:40 PM
  7. Pivot Tables/Summarizing data by months
    By hailnorm in forum Excel General
    Replies: 0
    Last Post: 01-24-2005, 06:29 PM

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