1 Reply Latest reply on Jul 12, 2016 10:06 AM by Tom W

    Use dimension names as row values; dimension values as column names

    Tom Gervais

      I have several dimensions that have the same possible values: "True", "False", "Unknown".  The data is shown below

       

       

      PersonWealthyTallPlaysGolf
      MikeTRUEFALSETRUE
      FredFALSEFALSEUnknown
      TonyUnknownTRUETRUE
      GwenTRUEUnknownTRUE
      AliciaTRUEFALSETRUE
      MaryTRUEUnknownTRUE
      WillFALSETRUETRUE
      NickTRUEFALSEUnknown

       

      What I'd like to do is use the dimensions (Wealthy, Tall, PlaysGolf) as row labels, and use the dimension values (True, False, Unknown) as Column headers. It should look something like the following:

        

      TRUEFALSEUnknown
      Wealthy242
      Tall531
      PlaysGolf611

       

      Is this possible? I've attached a workbook with the excel sheet attached.

       

      Thanks for your assistance.

       

      Tom