4 Replies Latest reply on Apr 5, 2013 10:12 AM by Udi Schlessinger

    How can I get a summary variable for a row while still getting individual breakdowns

    Udi Schlessinger

      Hello,

       

      I'm trying to do something that's very simple in SQL and yet I am unable to do this in tableau.

       

      I've been able to created a table that does, say,

       

       

                              Vegetarians       Smokers          Non-Smokers       Meat Eaters

      Nationality           

      American                   3              2                                                       1

      Indian                        15             4                                    3                 2

      Chinese                     9                                                                        1

       

          

      Doing this is very easy. But what I want to do is get the *distinct* number of users per row. So in the case of American, it would be 4, in the case of Indian it would be 24, in the case of Chinese it would be 10.

       

      This is not a straightforward summary of all users per row. In other words, I just a summary of the distinct user per category ("American", "Indian", "Chinese") but still get the breakdown. This would just be an extra row in the table.

       

      Please can you help?

       

      Thanks