Hello To all and hope all are doing well in this pandemic.
I have a pivot table and would like different information from the same column. I can sometimes make it work and sometimes not. What am I doing wrong?
On the "Rows", I drop down the column labeled "Implemented By"
On the "Values" I drop twice the column labeled "Month Live on EPCS"
I would like for Value to reflect the count of items that have data
and on the other , the count that don't have data.
How can this be accomplished. When I do the drop down its a hit or miss.
I provided the excel
Bookmarks