11 Replies Latest reply on Oct 23, 2013 4:01 AM by Ville Tyrväinen

    Counting items across multiple columns

    Anuja S Krishnan

      I have multiple columns with the set of items (1-20) and would like to get a count of unique items across these columns.

       

      I am attaching a sample .twbx. I want to know the count of 1s, 2s, .... 20s across columns C and D (GroupA and GroupB).

       

      I am able to do this for one column (e.g. GroupA) by moving it to Dimensions. How can I get a count across two columns?

       

      Also, I would also like to see the count by Gender and Age. Is reshaping the only way to do achieve this?