2 Replies Latest reply on Nov 29, 2018 10:07 AM by none given

    LOD Used for Many-to-Many, % of Total

    none given

      I have 20 users, and each user has a unique set of options for transportation.  I'm trying to compare how each transportation option does vs other transportation options when a user has both options available.  I've gotten to where I can individually compare them (Sheet "individual comparison"), but I'd really like an overall comparison so you don't have to go through each individual instance.

       

      Attached is a workbook and the desired output.  The output example picture I've attached is for "Bus" relative to everything else.  It's the bus percent of total, (aka choice percentage).

       

      Thanks!