Consulting

Results 1 to 2 of 2

Thread: Pivot table to NOT summarize data?

  1. #1
    VBAX Tutor
    Joined
    Mar 2005
    Posts
    221
    Location

    Pivot table to NOT summarize data?

    I have a data sheet with information I would like to send out for people to verify. There are columns in there that are hierarchy, so they can pick their own team to verify the data.

    Is it possible to setup a pivot table and just show the raw results?

    Example, say I want to just drill down by manager, and see the people and their information , without counts, sums, avg, just showing straight data ... is that possible?

    example sheet setup :

    employeeid, name, id1, salary, manager.

  2. #2
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    7,195
    Location
    AFAIK you have to have a Data field, but you could use employeeid as a Row value and as a Data value and it will show "Count of".

    YOu could always hide that column if you want

    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •