Pivot table follow up question

  • 1.  Pivot table follow up question

    Posted 08-10-2020 09:45 AM
    OK...those of you on the Sat Session...here is the challenge.

    See if you can figure out how to create a Pivot Table that lists the info below.  The "trick" is to see if you can figure out how to add the percentage column for the fail number and the pass number which Scot was asking about.

    BONUS...insert a slicer so only one hospital or several hospitals are displayed (snip 2 at the bottom)

    As folks mentioned during the session...slicers can open up a whole new dimension of data analysis and enables a dynamic element in presenting data during meetings.

    Snip 1:

    Snip 2 (shows results for Hospitals 1, 3, 5, and 7)

    -------------Frank "Snake Bite Leader" Ruelas--------------
    ► We don't fail unless we quit! ◄
    Bill Wong's Resource Folder: https://bit.ly/BillWong
    NEXT UP:
    Stay tuned...

    ░ Pass the Exam Group for 2020 ░
    Melissa Singleton - Jan - CHPC
    Julie Clutter - Jan - CHPC
    Tanisha Grant - Feb - CHC
    Lisa Bibby - Jan - CHPC
    Kelly Puida - Mar - CHPC
    Christina Serrano - Mar - CHC
    Rachel Anderson - May - CHC
    Melissa Alexander - June - CHC
    Theresa Veazey - June - CHC
    Barbara Zubeck - June - CHPC
    Patricia Radatz - June - CHC
    Anthony Fleming - July - CHC
    Laura Chaney - July - CHC
    James Maruyama - July - CHC
    Namrita Notani - July - CHC
    Lisa Campbell - August - CHC
    19th Annual CEI Virtual Conference