Results 1 to 11 of 11

Filtering by single employees in pivot table when the cell contains multiple employees

Threaded View

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

    Re: Filtering by single employees in pivot table when the cell contains multiple employees

    You are welcome and thanks
    Pivot Table looks like Magic Wand but it is not

    If you want to play with PowerQuery, add table to Data Model, then create new columns with Calculated Fields/Calculated Columns (divide Name column to the single names), transpose table and create PivotTable from new transposed table. (theory)
    Last edited by sandy666; 07-27-2017 at 11:13 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count Number of Employees Per Month Using Pivot Table Excel 2010
    By mclarke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2017, 04:21 PM
  2. Replies: 1
    Last Post: 02-29-2016, 06:11 PM
  3. Assigning tasks to employees and moving between employees
    By sbo123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2014, 10:37 AM
  4. Replies: 0
    Last Post: 09-09-2014, 07:38 AM
  5. Forecast How Many Employees To Hire Based on Active and Termed Employees
    By Kanook22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2014, 01:19 PM
  6. Replies: 2
    Last Post: 03-11-2013, 09:59 PM
  7. Replies: 4
    Last Post: 11-28-2010, 11:00 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