+ Reply to Thread
Results 1 to 2 of 2

Pivot - Counting only Single Cell Status

  1. #1
    Forum Contributor
    Join Date
    12-13-2011
    Location
    Grimsby, UK
    MS-Off Ver
    Office 2016
    Posts
    118

    Pivot - Counting only Single Cell Status

    I'm trying to put together a pivot that tracks the amount of actions that are still open from a pivot. The field has the options of 'open' or 'closed' and I only want to count those that are open but I'm having difficulty in only counting the 'opens'. How do I get excel to do this?
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,681

    Re: Pivot - Counting only Single Cell Status

    Select a cell in the pivot table, click the Insert tab, and choose Slicer, linking it to the Status tab, then just select Open in the slicer.
    Rory
    Days when we raged, we flew off the page
    Such damage was done

+ 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