1 Reply Latest reply on Jul 26, 2013 6:17 AM by Ashish Vidyarthi

    Displaying the COUNT of a unique value for multiple columns

    Anuja S Krishnan

      Here’s question 3, might be the easiest for you am guessing.

       

      I have a bunch of columns, each column has a bunch of “YES” and blanks. I want to create a table to show the count of “YES” in each column. I may also want to show this by another filter column.

       

      Here’s an e.g. of the data below, where a person in a given group answers a “YES” if he/she purchased that item.

       

      GROUP

      Item1

      Item2

      Item3

      Item4

      Item5

      A

      YES

      YES

      YES

       

      YES

      B

      YES

       

      YES

      YES

      YES

      C

      YES

      YES

       

      YES

      YES

      D

       

       

      YES

      YES

      YES

      A

      YES

      YES

       

      YES

       

      C

      YES

       

      YES

       

      YES

       

      I want to show the following:

       

      1. 1) The number of YES in each column i.e. how many people purchased each item.
      2. 2) The above table filtered by GROUP i.e. how many people in a given group purchased each item.

       

      Both “GROUP” and the 5 items are in the Dimensions box of my workbook.

       

      Thank you!