+ Reply to Thread
Results 1 to 1 of 1

I need Pivot table to only take certain data

  1. #1
    Registered User
    Join Date
    07-11-2019
    Location
    London,Ontario
    MS-Off Ver
    2010
    Posts
    1

    I need Pivot table to only take certain data

    Hello so my problem is I have a pivot table summary made from multiple sheets that tracks how many projects need that task done by month. (Below attached is the screen shots to better explain). So my problem is in my data tabs there is 3 options for the user to choose (p)- planned (c)- completed and (cr)-cancelled, i want my pivot table to ONLY pick up and reflect when people place (p)'s. The data sheet will always be changing with P's deleted or replaced with c/cr. Is there any way for it to only read the p's?
    Attached Images Attached Images

+ 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