+ Reply to Thread
Results 1 to 1 of 1

Pivot table irrelevant entries

Hybrid View

  1. #1
    Registered User
    Join Date
    06-20-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    1

    Pivot table irrelevant entries

    I am trying to perform some analysis on my companies client entertainment expenses. The pivot table is displaying the correct data but it also displaying entries from employees who haven't done any client entertainment but have claimed other expenses.

    Here is a link to a doctored screen of my pivot table, the entries circled red are irrelevant for my analysis hence the blank totals. How can I get them to disappear leaving just the ones that are for client entertainment with their totals.

    http://i39.photobucket.com/albums/e1...ableScreen.jpg

    Thanks
    Last edited by JSMartin; 06-20-2011 at 05:42 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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