How to handle yes and no fields in a pivot table in Excel

[@BarbHendersonconsulting]

Thank you so much for watching my video. If you have any suggestions for future topics please leave them in the comments below.

[@psychout09]

Thank you for this example... very helpful in a project I'm working on today. Much appreciated

[@BarbHendersonconsulting]

Glad it helped

[@princet52]

Won't it be simpler to add Survey to the filter and then toggle between yes and no as the situation demands?

[@TruthofDilly]

You are brilliant

[@BarbHendersonconsulting]

thanks!

[@ThunderliciousB]

thanks Barb for the video. Highly appreciated.

[@BarbHendersonconsulting]

You are so welcome!

[@jeroentournier]

And how would you go about this if there is no possibility of changing the source data?

[@Explorer_00-p5n]

Very helpful! But, question - can't we handle yes and no as categorical variables in pivot table instead getting the values to YES =1 AND No=0

[@BarbHendersonconsulting]

that would work!

[@villagewickets]

Thnx

[@BarbHendersonconsulting]

Welcome

[@isratjahan-sx7mn]

THANKS

[@BarbHendersonconsulting]

You're welcome!

[@pathopkins7400]

Okay I must have missed a step. I still get a count of all

[@harunarslan183]

Thanks. It was very helpful. clear and brief. @mustili3

[@BarbHendersonconsulting]

Glad to hear that!