3 Replies Latest reply on Mar 16, 2016 6:39 AM by Derrick Austin

    Display the most profitable product for each month

    Osoba Netko

      Hello guys =)

       

      I would like to ask you do you know solution for the problem I haven't find yet.

       

      In my database I have data for my fruits selling history. This is simple example:

       

      idcategory
      price
      # of itemsTotal priceMonth
      Date
      1Bananas4,9914,99Jan01.01.2016
      2Papaya3,9927,98Jan02.01.2016
      3Bananas4,9939,98Jan02.01.2016
      4Coconut4,4928,98Dec19.12.2015

       

      In tableu I would like to make table like this:

       

      CategoryMax Month
      BananasSeptember (5847,69)
      PapayaOctober (5183,5)
      CoconutDecember (8,98)

       

      I would like to display the top month for each fruit and value for this month.

       

      I hope this can be done.

       

      Thank you a lot. =)

       

      Mislav