1 Reply Latest reply on Mar 28, 2014 9:55 AM by Bill Palombi

    Hi Everyone, I am trying to create a table (I'm open to a chart too if that works best) to display "select all that apply" data.

    Amanda Bramlett

      I have a survey dataset that contains information about cup sizes and prices offered in restaurants.

      Each restaurant (one obesrvation) can have multiple cup sizes...so each cup size is a single field.

      For each selected cup size, the restaurant indicated a price. I have "averaged" these prices across restaurants to get the average cup price for each cup size.

       

      Example data:

       

      Store10oz20oz10ozPrice20ozPrice
      10011$.75$1.24
      11001null$1.30
      12001null$1.10

       

      Say I have 5 stores...I'd like to make a simple table with columns being:

      Cup Size OfferedStore CountPercent of StoresAvg Price
      10 oz360%$1.00
      20 oz5100%$1.30
      30 oz240%$1.50
      40 oz240%$1.75

       

       

      Can someone please help?