Really it was very useful, i have searched many videos but i haven't found. At last i found it here the solution. Tq very much for the solution. It is my 1st comment in youtube.
I have a Column J titled Failure Mode that employees are required to list a Failure Mode after part is inspected. I have a current pivot table that keep track of parts and status. I would like to keep track of the blank Failure Mode in the cell of that Column. How do I get the pivot table to show the amount of blanks for each employee while showing the status of work on the parts?
I'd make a new "FailCount" column in the table, with this formula: =(J2="")*1 It will return 0 if cell J2 is filled in, and 1 if empty. Add the new column to the pivot table, to get the count of "blanks"
Hi Debra. Thanks for the video. Always useful to practice new things in Pivot Tables. Thanks also for providing the sample workbook to follow along.. very helpful :)) Thumbs up!!
Everyone teaches how to hide blank cells, fortunately i found your video. Very heplful thanks
You're welcome, and thanks for letting me know the video helped you!
Really it was very useful, i have searched many videos but i haven't found. At last i found it here the solution. Tq very much for the solution. It is my 1st comment in youtube.
Thank you, Bharat, and I appreciate your kind words!
so much research and it was right under my nose, i just had to return something from a pivot table haha, tyvm!
You're welcome, and thanks for your comment! I'm glad you got it working
Thank you! So basically what I need is to add a consecutive in my table if this does not have it for your trick to work right?
You're welcome! And you need at least one column in the table that has an entry in every row. You could make a new column with this formula: =1
I have a Column J titled Failure Mode that employees are required to list a Failure Mode after part is inspected. I have a current pivot table that keep track of parts and status. I would like to keep track of the blank Failure Mode in the cell of that Column. How do I get the pivot table to show the amount of blanks for each employee while showing the status of work on the parts?
I'd make a new "FailCount" column in the table, with this formula: =(J2="")*1
It will return 0 if cell J2 is filled in, and 1 if empty. Add the new column to the pivot table, to get the count of "blanks"
@@contextures , Thank you for your help!
Hi Debra. Thanks for the video. Always useful to practice new things in Pivot Tables. Thanks also for providing the sample workbook to follow along.. very helpful :)) Thumbs up!!
Thank you, Wayne! I appreciate your long-time support
Where have you been lately , I have not seen one of your videos for a while ! ? 🧐🇬🇧🤔👍🏻🤝❤️
Thank you! I'll try to post videos more often 🙂
u r very good