2 Replies Latest reply on Sep 17, 2012 9:22 PM by Xiaodong Han

    Summary-Distribution result

    Xiaodong Han

      I have a marketing research dataset. The data layout is like this:

       

      WHAT IS YOUR AGE?HAVE CHILDREN UNDER 18 LIVING IN HOUSEHOLD?ARE YOU...?
      35-44YESMALE
      65 OR OVERNOFEMALE
      55-64NOFEMALE
      45-54YESFEMALE
      45-54NOFEMALE
      65 OR OVERNOMALE
      45-54NOFEMALE

       

      I got the data in tableau, want show result like this:

       

                     Gender                 Have Child

                     Male      Female       Yes           No

      25-35          x               y               z          w

      35-44          a               b               c          d

      45-54          e               f               g           h

      ...

      When I do it in Tableau, it alway nest the Gender and "Have child" question:

       

                Male               Female

                Yes     No         Yes     No

       

      Is there any way to separate the columns to prevent nesting?

       

      Thanks