+ Reply to Thread
Results 1 to 5 of 5

Pivot table and headings.

  1. #1
    Registered User
    Join Date
    05-19-2014
    Location
    california
    MS-Off Ver
    excel 2016
    Posts
    41

    Pivot table and headings.

    Hello,


    I need helping adding headers to pivot tables and filtering. Let me explain, we have a spreadsheet of all equipment that comes in for repair. Under this spreadsheet we have dates for when we received the equipment, when ship the equipment to the vendor when it comes back from the vendor and when it gets delivered back to the customer. we do not want to delete records of equipment being delivered back to customer, however, when trying to create a pivot table IT pulls all data, (this is because we have data that is already completed) but my goal is I would like for the pivot table to pull the data only from the records where we have not delivered the equipment back to the customer yet. am i explaining my self?. if the column has a delivery date to the customer, i don't want excel to consider that data. ONLY what has not been delivered to the customer. Also, i have headers on the columns and i would like for the headers to show up on the pivot table. can anyone help?>




    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Pivot table and headings.

    I'm not sure what end result you are looking for.

    If you just want to eliminate where "Return to Customer" is not blank, then why not just use Filter on the table?

    Or am I missing something here?

    If possible, can you create sample file with expected result after the operation (just what the data should look like)?
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    05-19-2014
    Location
    california
    MS-Off Ver
    excel 2016
    Posts
    41

    Re: Pivot table and headings.

    hi there, I am not sure if I am replying to the person that is trying help me, I am not sure how to use this very well. but here is a sample of what I like to get.


    thanks so much, please look at the pivot table I create don the 4th worksheet.

  4. #4
    Registered User
    Join Date
    05-19-2014
    Location
    california
    MS-Off Ver
    excel 2016
    Posts
    41

    Re: Pivot table and headings.

    hi there, I am not sure if I am replying to the person that is trying help me, I am not sure how to use this very well. but here is a sample of what I like to get.


    thanks so much, please look at the pivot table I create don the 4th worksheet.

    RADIOS.xlsx

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Pivot table and headings.

    try with: Design - Report Layout - Tabular Form and Design Subtotals - Don't show Subtotals and Design - Grand Totals - Off for rows and columns
    Attached Files Attached Files
    Last edited by sandy666; 12-14-2017 at 02:16 PM.

+ 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. How to make a Templates column headings dynamic with the Pivot table headings
    By DashBD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2017, 05:20 PM
  2. Pivot table won't use headings
    By tuph in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-03-2014, 11:05 PM
  3. Replies: 4
    Last Post: 07-22-2013, 10:22 AM
  4. Pivot Table Headings
    By jomili in forum Excel General
    Replies: 3
    Last Post: 10-06-2010, 11:36 AM
  5. Changing Pivot Table Headings
    By proline241 in forum Excel General
    Replies: 0
    Last Post: 12-12-2007, 04:00 PM
  6. [SOLVED] pivot table row vs column headings
    By mrs.champ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2005, 07:06 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