3 Replies Latest reply on Jun 21, 2017 2:30 PM by Ragav P

    Show only the Max Month for a category

    Ragav P

      Hello Guys,

       

      I am trying to find a solution for the below question. It would be really great if someone can shed some light.

       

      I want to show only the Max number of orders for each category for whole year & Max profit for each category for the whole year. Only the respective month value to be shown others should be null

       

      Max month each year.PNG

       

      Max Profit each year.PNG

       

      Any help here? Also I want them to be shown under the same view, possible? I tried using WINDOW_MAX function but seems like I am not using it in proper way definitely there needs to be something else with that. Let me know.

       

      Thanks.

      Ragav