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?
Bookmarks