+ Reply to Thread
Results 1 to 3 of 3

Pivot Table with Data instead of numbers

  1. #1
    Registered User
    Join Date
    05-12-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Pivot Table with Data instead of numbers

    Alright, here I am again looking for more help. I have attached the example below for details.

    I read multiple posts that indicate that you cannot use a pivot table to display the data text instead of the summarized number. Basically you know how you can click on the numbers in the pivot table and show the data behind it, that's what I want to show. I put an exampled in the sheet.

    I was thinking of doing some type of lookup of the owner in the sheet and counting how many times they show up and then displaying the results of the offset. But I am just not that smart to figure it out. Any help would be greatly appreciated from all you genius' out there.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Pivot Table with Data instead of numbers

    I could only get this far towards your preferred layout.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    05-12-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Pivot Table with Data instead of numbers

    Thanks for the suggestion, much appreciated.

+ 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. Replies: 14
    Last Post: 09-29-2014, 02:58 PM
  2. To Rounding off numbers in Pivot Table Data area using Macro
    By sanc.jobs2012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2012, 06:32 AM
  3. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  4. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  5. [SOLVED] Pivot Table - Rounding the numbers in the Data Area
    By Shatin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2005, 10:02 AM

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