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

How to handle yes and no fields in a pivot table in Excel. How to make yes and no values separate so they have more value in your data and charts. How to show what you need to show in a pivot table. Check out my templates page for free and purchased templates www.easyexcela...
Are you struggling to update your Microsoft SQL Server data?
I recommend using well-known Excel to update and manage your data in SQL Server using the SQL Spreads Excel add-in.
Click sqlspreads.com... to find out how SQL Spreads works best for non-technical end users and download our free 14-day trial. You will get two months free when purchasing an annual subscription using our link.
For more help visit my website www.easyexcelan... or email me at [e-mail].
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
www.crowdcast....
I use a Blue condensor Microphone to record my videos, here is the link
amzn.to/37gyyGa
Check out Crowdcast for creating your webinars
app.linkmink.c...
If you need to buy Office 2019 follow
amzn.to/2VX5dv8
I use Tube Buddy to help promote my videos
Check them out
www.Tubebuddy....
Follow me on Facebook
/ easyexcel.answers
TWEET THIS VIDEO • How to handle yes and ...
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
www.youtube.com...
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.

[@BarbHendersonconsulting]

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

[@TruthofDilly]

You are brilliant

[@BarbHendersonconsulting]

thanks!

[@psychout09]

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

[@BarbHendersonconsulting]

Glad it helped

[@ThunderliciousB]

thanks Barb for the video. Highly appreciated.

[@BarbHendersonconsulting]

You are so welcome!

[@princet52]

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

[@jeroentournier]

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

[@isratjahan-sx7mn]

THANKS

[@BarbHendersonconsulting]

You're welcome!

[@missadventure7564]

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!

[@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!