9 Replies Latest reply on Jun 17, 2015 8:12 AM by Jesse yung

    Calculate number of stores which meet the top category criteria

    Jesse yung

      hi, i have a table like this

      Store

      Product

      Amount

      Day

      A

      Apple

      116

      1

      A

      Banana

      83

      1

      B

      Apple

      135

      1

      B

      Pineapple

      147

      1

      B

      Pear

      86

      1

      C

      Apple

      139

      1

      C

      Apricot

      54

      1


       

      for each day, how can i obtain how many stores are there having apple as their top product?

      Desired output

      Day1Day2
      # (no. of stores)#

      Thanks